Create pivot table in excel using VB.Net and C# in ASP.Net

Question

HiCan I get sample of code for create pivot table in excel data from external using vbnetCreate based on SQL databaseYour help highly appreciated Thanks

Indresh · Accepted Answer

Hi hemma123Please refer the below code You need to modify as per your requirementCprivate void GeData    string connection  34OLEDBProviderSQLOLEDB1Integrated SecuritySSPIServer19216801SQL2005DataBaseTestUIDsaPWDpass12334    string command  34SELECT Column1Column2Column3Column4castColumn5100Column4 AS DECIMAL162 as Column5  FROM  PivotData34    ExcelApplication app  new MicrosoftOfficeInteropExcelApplication    ExcelWorkbook workbook  MicrosoftOfficeInteropExcelWorkbookappWorkbooksAddTypeMissing    ExcelWorksheet sheet  MicrosoftOfficeInteropExcelWorksheetworkbookActiveSheet    ExcelPivotCache pivotCache  appActiveWorkbookPivotCachesAddExcelXlPivotTableSourceTypexlExternal ExcelRangesheetgetRange34A134 34E1034    pivotCacheConnection  connection    pivotCacheMaintainConnection  true    pivotCacheCommandText  command    pivotCacheCommandType  ExcelXlCmdTy

Create pivot table in excel using VB.Net and C# in ASP.Net

Company

Explore

Follow us

Contact Us