Rename Worksheet

debasis.mishra · March 3, 2011, 4:32pm

Hi,

What is the syntax to rename excel worksheet present in testing.xls

Suppose my excel name is testing.xls
The worksheet name is sheet1.

I want to change this worksheet name from sheet1 to TAB11.

Thanks in advance.

Perderabo · March 3, 2011, 5:31pm

You just select the text in the tab, backspace over the "sheet1" and type whatever you want. But I have no idea how to do it with a shell script. Is this really a shell scripting question?

Scott · March 3, 2011, 5:40pm

I suppose the closest "parallel" we could make this to a "Shell Scripting" question would be to export the .xls file to an .xml file (a "Save As" option of Excel), modify that, then import it back to Excel?