[sagar01sumi]

how can I read data from exel file and also can edit exel file with out opening exel file from C.

[sensui]

Do you mean EXCEL ( .XLS; the Microsoft proprietary format for spreadsheets ) or EXE ( the Microsoft Portable Executable format for executables ) ?

[gabehabe]

Pretty sure he/she said "Excel" plenty of times

The best way to do it is with a CSV file (comma separated) since it's the easiest format to work with.

[mangesh.kadu]

gabehabe, on 10 Sep, 2008 - 03:09 AM, said:

Pretty sure he/she said "Excel" plenty of times

The best way to do it is with a CSV file (comma separated) since it's the easiest format to work with.

How to do with csv file could you tell me or do u have any tutorial?

[no2pencil]

Excel is a program that can open spreadsheets. Surely you have a much more direct goal in mind? A specific file type perhaps?

mangesh.kadu, on 21 Jan, 2009 - 10:16 PM, said:

How to do with csv file could you tell me or do u have any tutorial?

You would have to parse the csv.

[matthew180]

Although Excel will read (and can be made to write) CSV files, that is not the same as a native .xls file. Are you trying to produce a file that Excel can consume, or are you trying to do something with a native .xls file produced by Excel?

If you are trying to read a native .xls file, then good luck and tell me how you did it. Microsoft does not publish their native formats (.doc, .xls, etc.) so any programs that do read the files directly have required people doing reverse engineering to figure out how the files are structured (even then they cannot be certain they cover every possibility). The NTFS is a similar situation and the reason you don't see many alternate operating systems with the ability to *write* to an NTFS file system. Anyway, I digress.

The CSV solution is a good option if you are producing files for Excel to consume, or if you can control what Excel produces (i.e. use save-as to produce a CSV file). However, CSV will only support row and column data, there can be no other "spreadsheet" type information in a CSV file like formulas, layout information, etc..

Matthew

[haiyun211]

matthew180, on 21 Jan, 2009 - 08:44 PM, said:

Although Excel will read (and can be made to write) CSV files, that is not the same as a native .xls file. Are you trying to produce a file that Excel can consume, or are you trying to do something with a native .xls file produced by Excel?

If you are trying to read a native .xls file, then good luck and tell me how you did it. Microsoft does not publish their native formats (.doc, .xls, etc.) so any programs that do read the files directly have required people doing reverse engineering to figure out how the files are structured (even then they cannot be certain they cover every possibility). The NTFS is a similar situation and the reason you don't see many alternate operating systems with the ability to *write* to an NTFS file system. Anyway, I digress.

The CSV solution is a good option if you are producing files for Excel to consume, or if you can control what Excel produces (i.e. use save-as to produce a CSV file). However, CSV will only support row and column data, there can be no other "spreadsheet" type information in a CSV file like formulas, layout information, etc..

Matthew

Hi Matthew,

I was wondering if you know how to make it so I can store data in CSV file and then recall that data? And also how to write the data to a file without overwriting the origanal data?

This post has been edited by haiyun211: 11 August 2009 - 12:18 PM

[jeff666]

matthew180, on 21 Jan, 2009 - 08:44 PM, said:

If you are trying to read a native .xls file, then good luck and tell me how you did it.

It's trivial with COM, same methods than on Win95 (dozens of samples in MSDN in VB, C and C++...)
You don't care about XLS format with COM...

This post has been edited by jeff666: 12 August 2009 - 02:51 AM