Hello there,I am using XIsIO in my application,but I got an error with these steps(language is C#):
1,open "a.xlsx" and "b.xlsx" as:
ExcelEngine engine=new ExcelEngine();
IApplication excelApp=engine.Excel;
IWorkbook aBook=excelApp.Workbooks.Open("a.xlsx");//there is 1 sheet in a.xlsx
IWorkbook bBook=excelApp.Workbooks.Open("b.xlsx");//there is 1 sheet in b.xlsx
2,create a new sheet in "a.xlsx" as:
IWorksheet aNewSheet=aBook.Worksheets.Create();
3,copy data of the sheet in "b.xlsx" into "aNewSheet" as:
IWorksheet bSheet=bBook.Worksheets[0];
bSheet.UsedRange.CopyTo(aNewSheet.Range["A1"],ExcelCopyRangeOptions.All);
4,save and close items
bBook.Close();
aBook.SaveAs("newA.xlsx");//Error
aBook.Close();
In the step 4,I got an Exception(my computer is Japanese OS ,so the error message is Japanese):
指定された引数は、有効な値の範囲内にありません。
パラメータ名: reference
場所 Syncfusion.XlsIO.Implementation.WorkbookImpl.IsExternalReference(Int32 reference)
場所 Syncfusion.XlsIO.Implementation.FormulaUtil.HasExternalReference(Ptg[] ptg)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.Excel2007Serializator.SerializeSimpleFormula(XmlWriter writer, FormulaRecord formulaRecord, CellRecordCollection cells)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.Excel2007Serializator.SerializeCell(XmlWriter writer, BiffRecordRaw record, RowStorageEnumerator rowStorageEnumerator, CellRecordCollection cells, Dictionary`2 hashNewParentIndexes, String cellTag)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.Excel2007Serializator.SerializeCells(XmlWriter writer, RowStorage row, CellRecordCollection cells, Dictionary`2 hashNewParentIndexes, String cellTag)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.Excel2007Serializator.SerializeRow(XmlWriter writer, RowStorage row, CellRecordCollection cells, Int32 iRowIndex, Dictionary`2 hashNewParentIndexes, String cellTag, Boolean isSpansNeeded)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.Excel2007Serializator.SerializeSheetData(XmlWriter writer, CellRecordCollection cells, Dictionary`2 hashNewParentIndexes, String cellTag, Dictionary`2 additionalAttributes, Boolean isSpansNeeded)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.Excel2007Serializator.SerializeWorksheet(XmlWriter writer, WorksheetImpl sheet, Stream streamStart, Stream streamConFormats, Dictionary`2 hashXFIndexes)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.WorksheetDataHolder.SerializeWorksheetPart(WorksheetImpl sheet, Dictionary`2 hashNewXFIndexes)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.WorksheetDataHolder.SerializeWorksheet(WorksheetImpl sheet, Dictionary`2 hashNewXFIndexes, Dictionary`2 cacheFiles)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.SaveWorksheet(WorksheetImpl sheet, String itemName, Dictionary`2 hashNewXFIndexes, Dictionary`2 cacheFiles)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.SaveSheet(WorksheetBaseImpl sheet, String itemName, RelationCollection relations, String workbookPath, Dictionary`2 hashNewXFIndexes, Dictionary`2 cacheFiles)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.SaveSheets(RelationCollection relations, String workbookItemName, Dictionary`2 hashNewXFIndexes, Dictionary`2 cacheFiles)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.SaveWorkbookPart(Dictionary`2 hashNewXFIndexes, Dictionary`2 cacheFiles)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.SaveWorkbook(ExcelSaveType saveAsType)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.SaveDocument(ExcelSaveType saveType)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.SaveDocument(Stream stream, ExcelSaveType saveType)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.SaveDocument(String filename, ExcelSaveType saveType)
場所 Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.Serialize(String fullName, WorkbookImpl book, ExcelSaveType saveType)
場所 Syncfusion.XlsIO.Implementation.WorkbookImpl.SaveAs(String FileName, ExcelSaveType saveType, ExcelVersion version)
場所 Syncfusion.XlsIO.Implementation.WorkbookImpl.SaveAs(String FileName)
If only doing copy "UsedRange" to different sheets in same XLSX file,it will be ok.
Any ideas?