Advanced Search

Question: Trouble with importing excel sheet

Question:Trouble with importing excel sheet

Christopher2222 5785
import exceltools
September 09 2015
0

I was having trouble importing an excel sheet

with(ExcelTools):
a:=Import("c:/inquire.xls","test1a.tabs","A2:B50")

  Error, (in ExcelTools:-Import) There was an error reading the Excel file

The excel sheet only had one tab visible named test1a.tabs

However it loaded fine without the range and sheetname specified
      a:=Import("c:/inquire.xls")
             

and it loaded fine using the sheet name as a number

     b:=Import("c:/inquire.xls",1,"A2:B50")

             

 

I was wondering if anyone else experienced this or if I was doing something wrong someone could point out.

 
Please Wait...