Exporting to Excel Plz help
-
Hi All, Iam having aproblem with export to Excel. What i want to do is that, I want to export the contents of a datagrid to excel-The features should be 1. Open,Save and Cancel Buttons 2. The Excel spreadsheet should be formatted to the best fit width for all cols with header in a font Arial, SIze 10, Bold, White text color,and Blue backcolor for the heading 3. The Excel File need only to contain only one sheet with name say 'AAA'. Kidly put in ur suggestions and Plz help to solve this out. Thank u. Regards, jeeva:)
-
Hi All, Iam having aproblem with export to Excel. What i want to do is that, I want to export the contents of a datagrid to excel-The features should be 1. Open,Save and Cancel Buttons 2. The Excel spreadsheet should be formatted to the best fit width for all cols with header in a font Arial, SIze 10, Bold, White text color,and Blue backcolor for the heading 3. The Excel File need only to contain only one sheet with name say 'AAA'. Kidly put in ur suggestions and Plz help to solve this out. Thank u. Regards, jeeva:)
I met this problem several weeks before. i recommend u to use xsl, this article [^] does help me a lot! wish u could succeed!;P Regards, Steven
-
I met this problem several weeks before. i recommend u to use xsl, this article [^] does help me a lot! wish u could succeed!;P Regards, Steven
Hi Steven, Thanks for the link. I did try it out as per ur link but its for VS.NET-2005 but i need it for 2003. Some functions are not compatible in this version. Plz Help. Regards, Jeeva:) -- modified at 2:59 Saturday 14th October, 2006
-
Hi Steven, Thanks for the link. I did try it out as per ur link but its for VS.NET-2005 but i need it for 2003. Some functions are not compatible in this version. Plz Help. Regards, Jeeva:) -- modified at 2:59 Saturday 14th October, 2006
I see,it is XslCompiledTransform, in vs2003 we use XslTransform instead of it. In the FAQ of that article there is some detailed info about it(its name is "Net 1.1 version").;P Regards Steven
-
I see,it is XslCompiledTransform, in vs2003 we use XslTransform instead of it. In the FAQ of that article there is some detailed info about it(its name is "Net 1.1 version").;P Regards Steven
Thanks Steven. I got the program working but i wasn't used to the XSL. After go'g thru the necessary docs i became somewhat familiar with that too. Still the data from the dataset is not getting populated in the Excel sheet. As I went thru the XSl doc i came to know that "" The select keyword will select data from each inner node as per the depth specified. But here instead of XML file we are using dataset. "" The select in here ---say "ProductID" IS it the field names that should be given as per our select commnd. Is my problem something to do with the above. Can u Plz suggest a possible solution for the same. Thanks & Regards, Jeeva:)
-
Thanks Steven. I got the program working but i wasn't used to the XSL. After go'g thru the necessary docs i became somewhat familiar with that too. Still the data from the dataset is not getting populated in the Excel sheet. As I went thru the XSl doc i came to know that "" The select keyword will select data from each inner node as per the depth specified. But here instead of XML file we are using dataset. "" The select in here ---say "ProductID" IS it the field names that should be given as per our select commnd. Is my problem something to do with the above. Can u Plz suggest a possible solution for the same. Thanks & Regards, Jeeva:)
dataset is ok, i am just using dataset, u could use: strExcelFile= objExport.TransformDataTableToExcel(ds.datatable(i),True) objExport.SendExcelToClient(strExcelFile) Also u have to have some polishment of ExcelExport.vb so as to run it in vs2003. If u have any more question, u could sent email to me. wish u could succeed!;P Regards, Steven