quote:

---

But I got one problem by using graph template, the count of my columns is not fixed every time, and it means I need to update the data source every time. Do you have any better solution?

---

 
void ImportFromExcelWksheets(string filePath){
	// Declare Excel objects
	Object	oExcel, oExcelWkbks, oExcelWkbk, oExcelWksh, data;
	
	// 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;
	
	// Bring up wait cursor
	waitCursor wCursor;	
	printf("Processing...\n");
	
	// Open the workbook with data to be analyzed
	oExcelWkbk = oExcelWkbks.Open(filePath);
	if(oExcelWkbk){
		foreach(oExcelWksh in oExcelWkbk.Worksheets){  
			
			Worksheet wk;
			wk.Create();
			data = oExcelWksh.UsedRange;
			int endRow = data.Rows.Count + data.Row - 1;
			int endCol = data.Columns.Count + data.Column - 1;
			wk.SetSize(endRow, endCol);
			//wk.Name(oExcel.Name);
			string value;
			for(int i = data.Row - 1; i < endRow ; i ++)
				for(int j = data.Column - 1; j < endCol; j ++){
					value = oExcelWksh.Cells(i + 1, j + 1).Text;
					if(!value.IsEmpty())
						wk.SetCell(i, j, value);
				}
		}
	}
	oExcel.Quit();
}
				

void ImportFromExcel(){
	// Get file path
	string filePath;
	filePath = GetOpenBox( FDLOG_EXCEL );
	
	// Processing
	if(!filePath.IsEmpty()){
		ImportFromExcelWksheets(filePath);
	}
}