At 14:26 2007-01-19, Thomas Hruska wrote: >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.
I heartily agree w/ Tom here. It's trivial to write a CSV (bad name... I use tabs '\t' and end of line '\n' to delimit fields and records respectively. it's easy to write, readable by humans (and you don't have to worry about weirdness in the fields then use "...." and escape the "s. Excel (or any rational spreadsheet) can read (import) tab/newline delimited files. >-- >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/ > > > >To unsubscribe, send a blank message to ><mailto:[EMAIL PROTECTED]>. >Yahoo! Groups Links > > > Victor A. Wagner Jr. http://rudbek.com The five most dangerous words in the English language: "There oughta be a law"
