Forum Discussion

anumolu9999's avatar
anumolu9999
Contributor
5 years ago

Working With Excel Files via COM: set required sheet as active using javascript

I am using excel, which has two sheets. I have to use COM to read excel because of microsoft access database issue. I have to access the second sheet in the excel based on its name.   Code is as b...
  • SebastianP's avatar
    SebastianP
    5 years ago

    Try this out,

    filePath="C:\Users\sebastian\Desktop\Sample.xlsx";

    SheetName="Sheet2";

    Excelbook= Excel.Workbooks.Open(filePath);
    var xlsheet = Excel.ActiveWorkBook.WorkSheets.Item(SheetName);

     

     

    I am using the aove and its working 

SebastianP's avatar
SebastianP
New Contributor
5 years ago

Try this out,

filePath="C:\Users\sebastian\Desktop\Sample.xlsx";

SheetName="Sheet2";

Excelbook= Excel.Workbooks.Open(filePath);
var xlsheet = Excel.ActiveWorkBook.WorkSheets.Item(SheetName);

 

 

I am using the aove and its working 

  • sonya_m's avatar
    sonya_m
    SmartBear Alumni (Retired)
    5 years ago

    Thank you everyone for help! 

    Hi anumolu9999  , did you find a solution? Did you have a chance to try what SebastianP is suggesting?