|
Formating data in Excel using c# -- swayze --
Hi All, our company gets data from another company in very large excel files. From this data, our graphic designer must format and style this data in order to create printable books for our customers. Since this is a long process, I have been asked to come up with a solution to automate the process. I've googled the subject and found some info, but not all that much. I've been able to merge cells, center them, look for text and now I cant find how to delete a column. the problem is that they come in a specific format: row->1 This is the first cell in the first row that spans 3 columns row->2 this is column 1 | this is column 2 | and this is column 3 row->3 this is column 1 | this is column 2 | and this is column 3 etc... so I guess my questions for now are: 1) how can I delete column 2 without affecting the 1st row? 2) how can I specify a range from A1 to ZZ where ZZ is the last column? I am using this syntax: "excelWorksheet.get_Range("A1", "Z1").VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;" But, after Z columns get named AA, AB and so on. thanks in advance for your time Swayze |
|
-- Raj --
How about if you get your excell data in Data Table and then manipulate ? .... Raj |