0

I have tow files that only differ in extention name, one xls ,the other xlsx.both contained the same things,same structure.there's no problem when I registered a table in xls,but when in xlsx,an error occured.

enter image description here

code list:

Include "mapbasic.def" Include "menu.def" Include "icons.def"

Declare Sub main Declare Sub Combine

Sub main Register Table "C:\Documents and Settings\Administrator\desktop\test\fdd.xlsx" TYPE xls

End Sub

  • Short-time solution: save the .xlsx-document as .xls instead. – Martin Jan 21 '14 at 10:32
  • 1
    which version of MapInfo and Office you are using ? – sys49152 Jan 21 '14 at 10:35
1

Register Table "C:\Documents and Settings\Administrator\desktop\test\fdd.xlsx" TYPE XLS Range "Sheet1" Interactive Into ... + ".TAB"

Maybe you have to translate "Sheet1" into the language version of your Excel.

For Example --> in German you should change it to "Tabelle1"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.