Click here to Skip to main content
15,943,362 members
Home / Discussions / C#
   

C#

 
GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
taibc4-Apr-13 21:48
taibc4-Apr-13 21:48 
GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
Mycroft Holmes4-Apr-13 22:02
professionalMycroft Holmes4-Apr-13 22:02 
GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
taibc4-Apr-13 22:05
taibc4-Apr-13 22:05 
AnswerRe: Problem about size with creating excel file using xml spreadsheet ? Pin
Eddy Vluggen4-Apr-13 22:30
professionalEddy Vluggen4-Apr-13 22:30 
GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
taibc4-Apr-13 22:43
taibc4-Apr-13 22:43 
AnswerRe: Problem about size with creating excel file using xml spreadsheet ? Pin
Eddy Vluggen5-Apr-13 0:28
professionalEddy Vluggen5-Apr-13 0:28 
GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
taibc5-Apr-13 0:34
taibc5-Apr-13 0:34 
GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
Eddy Vluggen5-Apr-13 7:00
professionalEddy Vluggen5-Apr-13 7:00 
As Richard notes, if you want to write a file in the native Excell-format, you'll have to InterOp to Excell. One problem to be expected is that the interop-libraries are tied to a specific version of Office. Use Office-2007 interop, and you'll be able to write .xls and .xlsx files. Do note that the native format is also tied to a specific Office-version. Second point is that one would need a license for Excell.

Alternatively, you could try searching for some third-party libraries. Most people will spit out an XML or CSV and not bother with it, unless there's a need to have some formatting in there.

Why is it such a big problem if the file grows a bit?
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
taibc5-Apr-13 17:55
taibc5-Apr-13 17:55 
AnswerRe: Problem about size with creating excel file using xml spreadsheet ? Pin
Richard MacCutchan4-Apr-13 22:37
mveRichard MacCutchan4-Apr-13 22:37 
GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
taibc4-Apr-13 22:41
taibc4-Apr-13 22:41 
GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
Richard MacCutchan4-Apr-13 23:29
mveRichard MacCutchan4-Apr-13 23:29 
GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
taibc4-Apr-13 23:36
taibc4-Apr-13 23:36 
GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
Richard MacCutchan4-Apr-13 23:41
mveRichard MacCutchan4-Apr-13 23:41 
GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
taibc4-Apr-13 23:51
taibc4-Apr-13 23:51 
GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
Richard MacCutchan4-Apr-13 23:54
mveRichard MacCutchan4-Apr-13 23:54 
GeneralRe: Problem about size with creating excel file using xml spreadsheet ? Pin
taibc4-Apr-13 23:57
taibc4-Apr-13 23:57 
Questioni use google maps api and can't remove single marker Pin
Asaf Shay4-Apr-13 13:05
Asaf Shay4-Apr-13 13:05 
QuestionAutomating website using c# windows form Pin
Nico Panares4-Apr-13 7:35
Nico Panares4-Apr-13 7:35 
AnswerRe: Automating website using c# windows form Pin
Eddy Vluggen4-Apr-13 9:38
professionalEddy Vluggen4-Apr-13 9:38 
QuestionHow to deny users from disabling my C# service Pin
candogu4-Apr-13 7:05
candogu4-Apr-13 7:05 
AnswerRe: How to deny users from disabling my C# service Pin
jschell4-Apr-13 9:24
jschell4-Apr-13 9:24 
AnswerRe: How to deny users from disabling my C# service Pin
Eddy Vluggen4-Apr-13 9:42
professionalEddy Vluggen4-Apr-13 9:42 
AnswerRe: How to deny users from disabling my C# service Pin
Dave Kreskowiak4-Apr-13 12:27
mveDave Kreskowiak4-Apr-13 12:27 
Questionhello Pin
youshy4-Apr-13 4:00
youshy4-Apr-13 4:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.