problem exporting to excel
-
is there a way to directly export SQL data to excel using a aspx page without displaying this data on a datagrid. so this is not like exporting from datagrid to excel but it is like...when user clicks a button then an Sproc is executed and data should be directly saved into excel. any help would be appreciated,thanks
-
is there a way to directly export SQL data to excel using a aspx page without displaying this data on a datagrid. so this is not like exporting from datagrid to excel but it is like...when user clicks a button then an Sproc is executed and data should be directly saved into excel. any help would be appreciated,thanks
Yes you can export data directly from SQL to xls file without displaying it in grid. Excel can be treated as SQL using connection string like following : "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DBQ=/book1.xls;UID=admin;" rows and colums are treated as html and or . I've done this work 3 years back on classic ASP. Don't get confused by the syntax. Cheers!
Regards, Saqib Umar Sr. Software Engineer