Generate files for excel safe and efficient

Question

I want to create a software probably in .NET or JAVA that will be connected with a digital scale. I want exported data to be able to open with Excel. What are my options ?

CSV file ?
Excel interop .net library?
Other?

I guess csv is a solution but doesnt allow any extra stuff.. However i dont want data to be lost so i think that in case of computer crash using interop .net file maybe be corrupted. In case with csv it wont be corrupted. Is there any alternative solution ?

What makes you think that a different file format will save you from random corruptions? — Oded, May 26 '12 at 17:34
csv wont corrupt the whole file ,but with another file format it might be hard to see any line... — GorillaApe, May 26 '12 at 17:45

score 1 · Answer 1 · edited May 23 '17 at 11:49

1

If you want to create Excel files, try to use OpenXML or some lib, which wrap it. To find some data in already existed file, OleDb can be faster.

edited May 23 '17 at 11:49

Community

1
1

answered May 27 '12 at 01:00

Unril

106
1
3

score 0 · Accepted Answer · answered May 27 '12 at 01:36

0

I'd prefer CSV as it is easier to move around from one system/language to another with fewer codes to change [Java to .Net or .Net to Java]

answered May 27 '12 at 01:36

codingbiz

26,179
8
59
96

Generate files for excel safe and efficient

2 Answers2