I created a report generation system that uses the RDC report component to create 6 different reports and export them to excel files. My only trouble is that the RDC only allows me to format very little of the resulting excel spreadsheet the way I want it.
Does anyone know how I can format a preexisting excel spreadsheet from my vb application? Or can someone point me in the right direction in how to get started? I just need to do things like, set the column sizes and possibly set field colors. Any help in getting me started would be greatly appreciated.
Thanks much,
CrystalVisualBOracle
Does anyone know how I can format a preexisting excel spreadsheet from my vb application? Or can someone point me in the right direction in how to get started? I just need to do things like, set the column sizes and possibly set field colors. Any help in getting me started would be greatly appreciated.
Thanks much,
CrystalVisualBOracle