Problem while editing an excel sheet in java

I am editing excel sheets using JExcel API.
If I edit 3rd sheet, next time when I open it using MS Excel 3rd sheet should be displayed default. (As if u do it using MS Excel)

Thanks
LVL 2
sandeep1984Asked:
Who is Participating?
 
TimYatesConnect With a Mentor Commented:
According to the documentation,  you can get the settings of a sheet using the getSettings method

http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/Sheet.html#getSettings()

Then the SheetSettings class has a setSelected method:

http://jexcelapi.sourceforge.net/resources/javadocs/current/docs/jxl/SheetSettings.html#setSelected(boolean)

I've not used it though, but I'd assume this is how it works...

Tim
0
 
ellandrdConnect With a Mentor Commented:
the getSetting() function will only return the setting for a specific sheet so unless you keep track of which sheet you last modified i dont think this function will work.

You could keep track by writing the sheet name to a text file when you write back to your Excel file.

Then do a quick check again when reading from the Excel file.  I have searched nearly all of the documentation and i cannot find any reference to a function that returns the last active or modified sheet.

ellandrd
0
 
sandeep1984Author Commented:
Thanks.
I am not going to open the excel sheet in my application, it will only be edited.
it will be opened using MS excel only.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
TimYatesCommented:
>>  I am not going to open the excel sheet in my application

??

Not sure what you mean here...
0
 
ellandrdConnect With a Mentor Commented:
do you not have to open the file to write to it?

I think your requirement is outside the scope of the Excel API to be honest.
0
 
ellandrdCommented:
I have no other comments to make on this question.  I have said what i needed to say above.
0
 
TimYatesCommented:
I feel that between myself and Ellandrd, the solution was given

Assuming that's ok with him that is :)

Either the file will need to be opened, the default sheet set, and the file saved again, or it cannot be done with this api...
0
 
ellandrdCommented:
Vee_Mod

There isnt a solution or are any of the comments above a solution.

If I was the asker, I would probably split the points if I was given help or advise even thought it wasnt a solution to my problem but that is my opinion.

Since the asker hasnt replied since 5th Dec 2007 which we all can see is nearly a month ago, myself and Tim have no idea on the current status of the problem.  Questions like this really tick me off sometimes as the asker might have a solution or workaround from our comments but hasnt bothered to PAQ this question.

Most questions like this usually get deleted without a refund and the experts who helped get nothing out of it.

Tim what do you think?  close it or split for helping?

Ellandrd
0
 
sandeep1984Author Commented:
Nobody is giving answers which is even near to my question.
I Think this question should be deletd.
0
 
TimYatesCommented:
Abandoning it for a month after we were trying to help you, even when we were asking for clarification to your requirements?

Nice...

Fair enough delete it, but there should be no refund of points...
0
 
Vee_ModCommented:
Finalized.
 
Thank you,
 
Vee_Mod
Experts Exchange Moderator
0
 
ellandrdCommented:
Thanks V!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.