+- 0Day Forums (https://0day.red)
+-- Forum: Coding (https://0day.red/Forum-Coding)
+--- Forum: JScript (https://0day.red/Forum-JScript)
+--- Thread: hide Excel tab from Javascript code (/Thread-hide-Excel-tab-from-Javascript-code)
hide Excel tab from Javascript code - tovaaud - 07-24-2023
How can I hide an Excel tab programmatically through Javascript.
ExcelSheetName.Visible=False doesn't seem to work. I've googled a lot but yet not received the right solution. How to do that ?
RE: hide Excel tab from Javascript code - palatine28116 - 07-24-2023
To hide an Excel sheet, set the `Visible` property of the corresponding `Worksheet` object to `0` or `false`.
For example, if you have an Excel file with two sheets named *Sheet1* and *Sheet2*, the following code will open this file with the *Sheet1* hidden:
var objExcel = new ActiveXObject("Excel.Application");
objExcel.Visible = true;
objExcel.Workbooks.Open("C:\\Book1.xlsx");
objExcel.ActiveWorkbook.Sheets("Sheet1").Visible = false;
// You can aslo use this --
//objExcel.ActiveWorkbook.Sheets("Sheet1").Visible = 0; // xlSheetHidden
<br/>
> So I said as u pointed out. This is my code:
> var fso = new ActiveXObject("Scripting.FileSystemObject");
> var xl = new ActiveXObject("Excel.Application");
> xl.Visible = true;
> var wb = xl.Workbooks.Open(fso.GetAbsolutePathName("Temp.csv"));
> xl.ActiveWorkbook.Sheets("Temp").Visible = false;
> But on doing so, I get the error as Unable to set the Visible property of the Worksheet class. Any clue what could be the possible error ?
The error is because CSV files have only one tab in Excel, and you can't hide the only visible tab. At least 1 tab must always be visible.