Increase the column limit in OpenOffice Spreadsheet

[Abhishek kumar]

Hi.

I am trying to work on a project which requires generation of an excel file using Java. I am using jxlapi for that. But I cant use column length more than 256 while i need around 1000.

Any suggestions how to accomplish it??

Thanks and regards.

--
Abhishek kumar,
2nd year,B.Tech,CS&E
SD24;Satpura House,
IIT delhi
(+91)9911848379

[Narendra Sisodiya]

On Mon, Oct 17, 2011 at 10:34 AM, Abhishek kumar <cs10...@cse.iitd.ernet.in> wrote:

Hi.

I am trying to work on a project which requires generation of an excel file using Java. I am using jxlapi for that. But I cant use column length more than 256 while i need around 1000.

Open Office 3.0 support 1024 column.

http://wiki.services.openoffice.org/wiki/Calc/hacks/number_of_rows 

Wait ...

are you saying jxlapi API do not support column over 256 Or you are saying that you cannon open a spreadsheet which has more than 256 column

[Abhishek kumar]

-- I am not sure. Compiling dint give any error. While running there was nothing like jxl doesnt support but it was more like  "Could not add cell at A303 because it exceeds the maximum column limit" . I think its the problem with spreadsheet.

Thanks.
 

--
Mailing list guidelines and other related articles: http://lug-iitd.org/Footer

--
Abhishek kumar,
3rd year,B.Tech,CS&E
NB3;Satpura House,
IIT delhi
(+91)9911848379

[Narendra Sisodiya]

On Mon, Oct 17, 2011 at 10:58 AM, Abhishek kumar <abhi.hak...@gmail.com> wrote:

On Mon, Oct 17, 2011 at 10:52 AM, Narendra Sisodiya <nare...@narendrasisodiya.com> wrote:

On Mon, Oct 17, 2011 at 10:34 AM, Abhishek kumar <cs10...@cse.iitd.ernet.in> wrote:

Hi.

I am trying to work on a project which requires generation of an excel file using Java. I am using jxlapi for that. But I cant use column length more than 256 while i need around 1000.

Open Office 3.0 support 1024 column.

http://wiki.services.openoffice.org/wiki/Calc/hacks/number_of_rows 

Wait ...

are you saying jxlapi API do not support column over 256 Or you are saying that you cannon open a spreadsheet which has more than 256 column

-- I am not sure. Compiling dint give any error. While running there was nothing like jxl doesnt support but it was more like  "Could not add cell at A303 because it exceeds the maximum column limit" . I think its the problem with spreadsheet.

Try to open in OOO 3.0 OR recompile OOO with edited max column.

[Abhishek kumar]

It was the problem with jxlapi :-/

I switched to apache poi and this got solved. :)

thanks

--
Mailing list guidelines and other related articles: http://lug-iitd.org/Footer

[ankit kumar]

post ur question on this forum javaranch.com

--

Mailing list guidelines and other related articles: http://lug-iitd.org/Footer

--

Regards
Ankit kumar

Pantnagar..
+91-9045937297

visit at : http://150.youthariseawke.org for INTERNATIONAL YOUTH CONFERENCE at Pantnagar University..... 
To receive a free inspiring and sparkling quote on mobile every morning, SMS- JOIN VSM_Pantnagar and send it to 567678. It's totally free. Tell it to friends also.