Hello friends,
it is primarily about reading large excel files with multiple worksheets in conjunction with the XL reader. I have tried a lot now, but I always come up against limits when several columns have to be addressed and I do not know exactly the arrangement of the information in the respective worksheet, or the programme is supposed to find the data itself without me knowing the correct column beforehand.
This is a bit abstract now, because I cannot serve with a program code.
Example:
There is a worksheet that stores the information of the 5 largest cities for several countries in the world. In column B is the capital of the first country, followed by 4 more cities in columns C, D, E and F. The capital of the next country can then be found in column G.
In the rows of the respective worksheets, hundreds of code numbers (number of inhabitants, area...) then follow one below the other.
Assuming that the cities are sorted alphabetically and that new cities are always added to the table, I have to implement dynamic addressing without knowing the detailed structure of the Excel worksheet. I have to search for the city within the columns and compare it with a search argument.
As I said, this is just an abstract example to illustrate my problem.
My biggest problem is that unfortunately I cannot now understand the necessary functions of the XLReader using the examples provided by Erel, how I could now specifically search for a city, these are unfortunately a bit too much oriented towards B4XTable examples. That's just as well. But I would like to export the data into an SQL table first, in order to be able to load it from this SQL table into a B4X table later.
Does anyone have some sample code or instructions for me on how to solve this problem with XLReader?
How does one get around the vexed problem of "letter addressing" the columns in an Excel spreadsheet? Is there a mode that can also address the columns numerically?
Many thanks in advance to all the people who are helping me to solve this problem.
it is primarily about reading large excel files with multiple worksheets in conjunction with the XL reader. I have tried a lot now, but I always come up against limits when several columns have to be addressed and I do not know exactly the arrangement of the information in the respective worksheet, or the programme is supposed to find the data itself without me knowing the correct column beforehand.
This is a bit abstract now, because I cannot serve with a program code.
Example:
There is a worksheet that stores the information of the 5 largest cities for several countries in the world. In column B is the capital of the first country, followed by 4 more cities in columns C, D, E and F. The capital of the next country can then be found in column G.
In the rows of the respective worksheets, hundreds of code numbers (number of inhabitants, area...) then follow one below the other.
Assuming that the cities are sorted alphabetically and that new cities are always added to the table, I have to implement dynamic addressing without knowing the detailed structure of the Excel worksheet. I have to search for the city within the columns and compare it with a search argument.
As I said, this is just an abstract example to illustrate my problem.
My biggest problem is that unfortunately I cannot now understand the necessary functions of the XLReader using the examples provided by Erel, how I could now specifically search for a city, these are unfortunately a bit too much oriented towards B4XTable examples. That's just as well. But I would like to export the data into an SQL table first, in order to be able to load it from this SQL table into a B4X table later.
Does anyone have some sample code or instructions for me on how to solve this problem with XLReader?
How does one get around the vexed problem of "letter addressing" the columns in an Excel spreadsheet? Is there a mode that can also address the columns numerically?
Many thanks in advance to all the people who are helping me to solve this problem.