Writing data to excel file through code in vc++
-
Hi, I am working with vc++. I need to write an excel file with the below format in VC++. Events Table - 1st row Description of table - 2nd row Date&Time,Source,Cause,Description,Fault - 3rd row Mar 13 2006 12:25:05.000078,HMI,H-0001,Startup,N Mar 13 2006 12:25:05.000187,HMI,H-0005,Caution,Y Basically the first row in the excel file must have the table heading, second row must have the table description and the third row will have the column names and fourth row onwards the actual data. I am able to create an excel file if all the rows have the same number of columns. But I am unable to create an excel file with different numberof columns in the rows as shown above. Can anyone please help me to do this. Thanks Madhavi.
-
Hi, I am working with vc++. I need to write an excel file with the below format in VC++. Events Table - 1st row Description of table - 2nd row Date&Time,Source,Cause,Description,Fault - 3rd row Mar 13 2006 12:25:05.000078,HMI,H-0001,Startup,N Mar 13 2006 12:25:05.000187,HMI,H-0005,Caution,Y Basically the first row in the excel file must have the table heading, second row must have the table description and the third row will have the column names and fourth row onwards the actual data. I am able to create an excel file if all the rows have the same number of columns. But I am unable to create an excel file with different numberof columns in the rows as shown above. Can anyone please help me to do this. Thanks Madhavi.
When u say Excel file, do you mean a .xls file? How did you go about creating the excel file. Please post more details! Have you tried using the Excel Object Model? --- With best regards, A Manchester United Fan The Genius of a true fool is that he can mess up a foolproof plan!
-
When u say Excel file, do you mean a .xls file? How did you go about creating the excel file. Please post more details! Have you tried using the Excel Object Model? --- With best regards, A Manchester United Fan The Genius of a true fool is that he can mess up a foolproof plan!
I am using the CSpreadSheet class from codeproject website: http://www.codeproject.com/database/cspreadsheet.asp but this class is not allowing to write data in the above format..