This topic is locked

OpenXML

7/19/2017 1:44:08 PM
ASPRunner.NET General questions
T
Tina author

Is it possible to use OpenXML with ASPRunner.net? I have an automated Excel import that needs to be coded and I'm looking at options.
Parameters are this:

There are about 8 different ranges that need to be imported at different times. User will press a button to start import which will correspond to the section of the template that needs to be imported. Everything will get imported into the same table. The table itself has 71 records per ID and rows are labeled 0-70 with 20 different fields in each row corresponding to different sections on the spreadsheet.
Example: \\xxx-Ellipsometry Spots.xlsx

If User is on Form A: then from spreadsheet above ranges a1:c4 (no headers are needed). The sequence is as follows User Clicks button,Search for spreadsheet in static location, if exists then:
Table A, xxx{ID}, Update

Row 1: FIELD2 = A1, FIELD3 = B1, FIELD4 = C1

Row 2: FIELD2 = A2, FIELD3 = B2, FIELD4 = C2

Row 3: FIELD2 = A3, FIELD3 = B3, FIELD4 = C3

Row 4: FIELD2 = A4, FIELD3 = B4, FIELD4 = C4