Excel in C# code - custom properties

[marianowic]

Hello.
I'm losing a battle with operating on Excel files in C# code.
I want to open an *.xls file in a C# code, do some modifications and
save it to a text file.
But I need to modify some options, like: date format, text without
double quota, column delimeter, itp. In short: a lot of staff. I'm
sure that this is possible, but I've got no bloody idea how.
I'm trying to do some with Worksheet.CustomProperties, but I don't
know if it is a correct path.
Have anyone got any idea??
Thanks... marianowic

 

[Guest]

Can you pls explain your self ? its very hard to understand the question.

 

[Rad [Visual C# MVP]]

Hello.
I'm losing a battle with operating on Excel files in C# code.
I want to open an *.xls file in a C# code, do some modifications and
save it to a text file.
But I need to modify some options, like: date format, text without
double quota, column delimeter, itp. In short: a lot of staff. I'm
sure that this is possible, but I've got no bloody idea how.
I'm trying to do some with Worksheet.CustomProperties, but I don't
know if it is a correct path.
Have anyone got any idea??
Thanks... marianowic

Why don't you try opening using OLEDB drivers instead of Excel
directly and manipulating your data directly? Of course this will only
work if your worksheet is properly structured with headings