How to select visibility of specific worksheet at the opening of Excel using Spreadsheet XML

Question

Hi,

I am getting spreadsheet xml from a code logic (Flex Grids to spreadsheet xml). I have 3 worksheets (A, B, C) in that spreadsheet xml. I am opening this spreadsheet xml in Excel. I want to view worksheet B when I am opening the spreadhseet xml in Excel.

Is there any tag/code, I need to add so that worksheet B will be visible at initial? I can add that code in code logic

Thanks ... Atul

Answer 1

Add tag in Namespace section of XMLSpreadsheet.

e.g. 1 , where 1 is the second worksheet of the spreasheet excel.