LT_execute("system.excel.openAsExcel=0;"); // 0 = open as Origin worksheet
LT_execute("system.excel.openAsPrompt=0;"); // Abfragedialog unterdruecken
Worksheet wks;
wks.Open(fqfn); 

int read_excel_sheet(string strExcelFileName, string strExcelSheetName, string strTempFileName)
{
	// Declare Excel objects
	Object	oExcel, oExcelWkbks, oExcelWkbk, oExcelWksh;
	
	// Create an Excel application object and set it as invisible
	oExcel = CreateObject("excel.application");
	oExcel.Visible = false;
	
	// Get the workbooks collection of the Excel object
	oExcelWkbks = oExcel.Workbooks;
	
	// Open the workbook with data to be analyzed
	oExcelWkbk = oExcelWkbks.Open(strExcelFileName);

	// turn off Excel messages
	oExcel.DisplayAlerts = FALSE;
	
	// Loop over each worksheet in the Excel workbook and find the specified sheet
	//write them out to the temp text file
	StringArray saFileNames;	
	string strSingleFile;
	BOOL bSheetFound = FALSE;
	foreach (oExcelWksh in oExcelWkbk.Worksheets)
	{
		string strName = oExcelWksh.Name;
		// Match wksheet name to specified name
		if(0 == strName.CompareNoCase(strExcelSheetName))
		{
			bSheetFound = TRUE;
			DWORD dwFileFormat = 20;
			oExcelWksh.SaveAs(Filename:=strTempFileName, FileFormat:=dwFileFormat);
		}
	}
	// Close Excel application
	oExcel.Quit();

	return bSheetFound;
}


// Use this function to test
//
void dd()
{
	// Change to your Excel path and file, and sheet name etc.
	string strExcelFileName = "D:\\temp\\MultipleWorksheets.XLS";
	string strExcelSheetName = "Sheet2";
	// Specify temp file name to use to store text file
	string strTempFileName = "D:\\temp\\temp.txt";
	int iFoundSheet = read_excel_sheet(strExcelFileName, strExcelSheetName, strTempFileName);
	if(iFoundSheet)
	{
		printf("Sheet %s was found!\n", strExcelSheetName);
		// Import text file into new wks
		WorksheetPage wpg;
		// Create using default template
		// Replace with your own template if you have custom ASCIMP settings
		wpg.Create("Origin.OTW");	
		Worksheet wks = wpg.Layers(0);			
		bool bRet = wks.ImportASCII(strTempFileName);
		if(!bRet) printf("Failed to import temp text file into wks\n");
	}
	else
		printf("Sheet %s was not found\n");
}

 wks.ImportASCII(strTempFileName);

quote:

---

Can I somehow pass the right filter name ("D:\\Origin_User\\filter\\import_filter.oif") to the ImportASCII-function (ore is there an other function provided to do so)?

---

quote:

---

Maybe as "system.excel.importSheetNo=2" (I would prefer that) or "system.excel.inmportSheetName="Sheet1""; May that be a feature?

---

quote:

---

The LT command
layer -s;
will connect the top Excel sheet to an internal Origin worksheet. Once connected, you can access this just like any worksheet. Maybe we need to add option for the layer -s command to connect a particular sheet.

CP

---

quote:

---

Is there a possibility to directly access an imported excel sheet (or it's cells) out of OriginC?

---

void load_excel(int nCol=0, int nRow = 3)
{
	string strFile;
	strFile = GetOpenBox("*.xls");
	if(!strFile.IsFile())
	{
		out_str("File not found");
		return;
	}
	
	string strLT = "doc -append ";
	strLT += strFile;
	LT_execute(strLT); // Load Excel workbook, we will provide OC command in SR1
	
	WorksheetPage	pg = Project.Pages(); // not clean, but once OC command added, will return page
	Worksheet		wks;
	wks = pg.Layers();
	if(wks == NULL)
		return; // something wrong
	wks.UpdateOrigin();
	
	printf("Exel value at R%dC%d is %f\n", nRow+1,nCol+1, wks.Cell(nRow, nCol));
	pg.Destroy();
}