shubhrajyoti datta wrote: > Hi, > > While using file operations how can an > exel sheet be populated or written to. > > I am not able to write to an exel sheet. > > With Regards, > Shubhro
Excel Spreadsheet files (.xls) are stored in a binary format. I think there's a hacked spec. of a pre-Excel 2000 format but supposedly OpenOffice can read _some_ Excel stuff, so you might start there: http://sc.openoffice.org/excelfileformat.pdf However, writing to an Excel document when the format isn't fully understood or known is generally a bad idea. You should use the Excel COM application object to manage the spreadsheet if possible. If not, you could use a CSV file and import it later. -- Thomas Hruska CubicleSoft President Ph: 517-803-4197 *NEW* VerifyMyPC 2.0 Change tracking and management tool. Reduce tech. support times from 2 hours to 5 minutes. Free for personal use, $10 otherwise. http://www.CubicleSoft.com/VerifyMyPC/
