How to insert more than 256 columns in a Open Office Calc sheet using c#?

Question

HI! friends

I have table contains 457 columns i need to ecport this table data to Open Office Calc spreadsheet. Uisng c# in asp.net

Can any one please help me.

Thank You!

Answer 1

You can't force Excel or OpenOffice to accept more columns than what is built in. Extraneon is right that only the latest versions of the office suites accept more than 256 columns so you could try that. But otherwise, you may have to rethink what you need to do.

Answer 2

Split it across sheets...

( But 457 COLUMNS??? smells bad!)

Answer 3

I would try very hard to make 2 spreadsheets,each with the index column and header of course, and split the columns over them. Perhaps even a third sheet sosummarize important columns & sums if you need those. That's not only more portable but more importantly more readable for users.

If different parties read the sheet (finance, sales, marketing, management) you could even make a sheet for each of those, only with the columns for these people. This is obviously no a technical solution, but spreadsheets are designed for humans so it makes sense to format them for readability.

And if you do need more than 256 columns you're stuck to openoffice 3.0 and higher.