Hello comunity!, Im asking this question to you for obtain a "trick" in the importation of huge amount of data from excel to mathcad prime v2, for automatically detecting the number of rows of data for the import process.
Supose that you have a software that generates an output file of 2 columns and variable quantity of rows, then you need to import it in your Prime sheet...so, what is your trick to do that?.
I can think of 3 ways for doing that:
- Use the Excel Component to compute the "range" of actual row data (like "DAT!A1:A300") and use in the "Out Expression" section. This trick dont work for me :[
- Previusly extract the "range" of values in an Excel Component, then copy/paste the component and use the past variable in the "Out Expression". That work, but required double Components (more spaces, more memory, etc).
- Use the Excel Component to compute the "number of rows with numbers" (like 200) and use an higher value of row for initially extract the raw data (for example, use a value of 5000 rows), then apply an redimension of the outputed data (using the function submatrix) with a number of rows equal to "row-1" for ORIGIN:=0. That's the trick I used every day.
I uploaded 2 files: an excel and mathcad file, please...put both of them in the same folder, then run the mathcad prime v2. I wrote my question there.
The best method that I wish to be able to work is the 1st..i.e using variables obtained in the "Out Expression" in the same Component..w/o using a 2nd Compoment, because the 3rd method use a lot of memory in my computations with huge data (20000 rows or more).
Please, help me with that..
Best regards,
Francisco Chavez Contreras
