Loading Excelsheet

Share icon

Hey,

I would like to import parts of an Excel-sheet into Igor. It works so far, but I have problems to provide the /R flag with a variable string.

This works fine:

XLLoadWave/R=(A1,C57810)/O/Q/Name="wave1;wave2;wave3" path


And this does not:

string area1
area1="(A1,C57810)"
XLLoadWave/R=($T0)/O/Q/Name="wave1;wave2;wave3" path

There must be a tiny little thing that I am overlooking...

Thank you,

Finn
Try this:
String startRow="A1", endRow="C57810"
XLLoadWave/R=($startRow,$endRow)/O/Q/Name="wave1;wave2;wave3" path

November 21, 2012 at 08:58 am - Permalink