4
Good afternoon dear friends, I have a project in hand where I have four spreadsheets, one of each "computer station management program" in which, in all of them, I have a column with the number of assets of the machine.
The vast majority of machines are in the 4 spreadsheets, but some are not, and that is my goal. I want to take these 4 sheets and put them in one, where I will have only 4 columns (of the 4 programs) and in the rows of these columns I want to put the equity number if it is present in the table referring to that column, leaving blank otherwise.
I would like this new table to be then in ascending order of patrimony being that in the line of patrimony 12345 for example, it is marked "12345 - 12345 - - 12345", assuming that it is not present only in the third column.
I am using jexcelapi, but I am a little lost in HOW to do this mapping, in order and etc. Anyone have any tips? I have no doubt about the code, just the logic of how to structure this program).
Grateful!
Guy has never seen jexcelapi. Data is stored in a list?
– DiegoAugusto
Let me get this straight, each of the 4 sheets has 1 column and multiple rows, and you want to convert this to 1 sheet with 4 columns and multiple rows? If yes, the relevant column of each sheet is column A?
– Victor Stafusa
Why are you using Java to do this? It’s easier and straightforward to do only in Excel...
– Luiz Vieira
Jexcelapi only has functions to read and write and manipulate, I keep where I want.
– Bruno Picciafuoco
And yes, I have 4 tables with a column of "primary key" equal in all, I want to turn into a table with only these 4 columns. I want to use this table to easily check which machine is not present in any of the tables
– Bruno Picciafuoco