Loading Delimited Text to Igor from Excel

Share icon

Tue, 06/19/2012 - 10:24 am

I currently have an excel file with 6 columns that are 318 cells long. I have it saved as an xml. When I attempt to load it into Igor as delimited text is spits back an error.

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">

Guest
2012-06-18T18:16:21Z
11.6360


8700
15195
0
105
False
False







It also states that the **name already exists**.
I've tried a lot of different methods for getting this to load, but I'm also relatively new to Igor. Any tips or help would be greatly appreciated. Thanks.
It's not clear what kind of Excel file you have but I guess it is a .xlsx file.

To load this, first determine the range of cells that you want to load (e.g., A1 to C10). Next determine which row in the Excel file contains column names, if any. Next choose Data->Load Waves->Load Excel File and use the dialog to load the file.

For details, execute:
DisplayHelpTopic "XLLoadWave XOP"


If you can not get it to work, send the file to WaveMetrics support along with an explanation of what you want to load from it, what you tried, what Igor version you are using and what OS.

June 19, 2012 at 11:10 am - Permalink