Looks like I was more than a little mistaken - at least from the point of
performing basic worksheet protection in the manner that you require. It is
possible to accomplish everything you wish using the SS model and so only
one codebase will need to be maintained irrespective of the workbooks type
Mark,
Thanks so much for your response.
Will wait for your answer on how to set password for a worksheet.
Also wanted to know if this is the way to set horizontalFreeze on a sheet:
sheet.createFreezePane(0, 1);
Thanks!
Shankar
--
View this message in context:
http://apache-poi.1045710.n5.nabb
Hello again,
1) Will my new worksheet be created as the first sheet always? Can i specify
the index of the sheet when creating it? Say workbook.createSheet("sheet1",
0) etc. Please clarify.
The worksheet wil always be created as the sheet at the next available index
number. So, when you create
Thanks Mark.
We are using SS user model for reading & writing the Excel files. As part of
this, we have created the workbook using:
workbook = WorkbookFactory.create(new FileInputStream(filename));
The next step is to create a sheet:
Sheet s1 = workbook.createSheet("MySheet");
Below are my quest
Whilst I am happy to help by answering specific questions relating to POI, I
do not have the time to devote to this sort of project, sorry. Further, I am
not an expert in using JExcel.
Yours
Mark B
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Equivalent-methods-in-A
Thanks Paul and Mark for your responses.
Please find the attached file
http://apache-poi.1045710.n5.nabble.com/file/n3336022/ExcelWrite.java
ExcelWrite.java for the code snippet we are using in our application. This
is coded using jExcel API. Now i want to rewrite the same code block using
Apac
Further to Paul's reply, also take a look at the Examples menu option that is
available from that same page. That takes you to many complete examples of
using POI to build - for example - an invoice.
With reyard to the WorkbookSettings clas, I do not think there is a direct
analogue in POI. Inste
Shankar,
I suggest you review the Excel Component API part of the POI website,
http://poi.apache.org/spreadsheet/index.html. The Quick Guide and HOWTO pages
will answer many of your question.
Paul Spencer
On Jan 7, 2011, at 9:58 AM, shankarrao wrote:
>
> Hi,
>
> We have used jExcel API in ou
