Batch Excel worksheet formatting

K

keithdm706

I am looking for a way to formatt excel worksheet cells from a batc
program and save the changes to that worksheet without opening th
worksheet.

I need to change the size of the cells in the worksheet, and als
change the formatt type of a numeric cell
 
T

Tom Ogilvy

For xl97 and earlier or non XML format excel files
Unless you are willing to understand the excel file format, compound
documents and decipher how this information is stored within, you will need
to use Excel as the engine to do these changes

For excel files stored as XML, then perhaps you can more easily discover the
appropriate data fields to change.
 
Top