- Jun 6, 2020
- 11,559
- 4,422
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...
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...
برای دیدن لینک ها باید ثبت نام کنید
برای دیدن لینک ها باید ثبت نام کنید