Hi Alban
Yeah, I can reproduce the issue.
It seems that the ability to detect the area to import is still somewhat limited to the 255 columns.
I can however import the full dataset if I manually overwrite this.
First I specify to use the full extent of a worksheet and check the Use Row above Selected Range for Column Titles.
Now From the Named Range list, I select Other, and in the Other Range dialog, I change the value to the full extent of the data in Excel.
In the example below, I have changed it from "IU5" to "VT5"

When I now move on with the process, MapInfo Pro loads the full dataset from Excel and gives me a table with 592 columns.
Sorry about the bit windy workaround here. I'll pass this onto support so that we can get this fixed fully.
Thanks for highlighting this issue (again), Alban.
------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------
Original Message:
Sent: 02-01-2021 04:21
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns
Hello,
I am on v2019.3 :(
looks like the problem is still there and yes I am using the extended tab format.
how to get a ticket raised?
thanks
------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
Original Message:
Sent: 02-01-2021 04:06
From: Peter Horsbøll Møller
Subject: import excel file >= 255 columns
Hi Alban
According to this discussion (Open excel file 250+ columns), this should have been fixed in MapInfo Pro v2019.1.
You raised the issue in the thread a year ago.
Have you been able to try out MapInfo Pro v2019.1?
You still need to ensure that you are using the Extended Tab format.
------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
Original Message:
Sent: 02-01-2021 00:42
From: Alban Spella-Barberet
Subject: import excel file >= 255 columns
Hello,
- Is there a way to import excel file having > 255 columns please?
- I tried converting to csv and import. It might work but the issue is that I have large integer which are converted and rounded to scientific notation which is not what I want. Is there a workaround on this?
Thanks.
------------------------------
Alban Spella-Barberet
NBN Co Limited
North Sydney NSW
------------------------------