C
C#2y ago
xinredi

❔ excel data processing

I have 4 excel files here, 100239421003 file contains a Statis page, other (_1, _2, _3, _4) files have a Detail page (contains 100239421003 file). Statis page and Detail page contain the Steps column, Steps is similar to the foreign key field in the database, to find the corresponding data in the Detail page according to the Steps in the Statis page, and get the maximum value of other columns and other information, Similar to (select max(Voltage(V)) from Detail where Steps='4') or (select * from Detail where Steps in(select Steps from Statis) where State='Rest')), now my practice is to first analyze the columns, and then create Statis table and Detail table, Statis table stores the Statis_33_12 page data in 100239421003, The Detail table stores the data of page 'Detail' whose Name contains 100239421003, *_1, *_2, and *_3. Is there another way to do it faster? For example, you can directly manipulate excel, but excel is very slow to retrieve harold
4 Replies
JakenVeina
JakenVeina2y ago
wat another way to do what faster? what is slow?
xinredi
xinrediOP2y ago
The process of importing sqlserver and aspose.cells to open and convert the DataTable is slow
JakenVeina
JakenVeina2y ago
what do you mean by "importing sqlserver"?
Accord
Accord2y ago
Was this issue resolved? If so, run /close - otherwise I will mark this as stale and this post will be archived until there is new activity.
Want results from more Discord servers?
Add your server