Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Mar 28, 2018 7:38 am

I try to marge .xls file, but i have this Exception.

private void button1_Click(object sender, EventArgs e)

{
Workbook newbook = new Workbook();
newbook.Version = ExcelVersion.Version2010;
newbook.Worksheets.Clear();

Workbook tempbook = new Workbook();
string[] excelFiles = new String[] { "readout_1125081210253405_1802271302.xls",
"readout_1125081210253405_1802271313.xls", "readout_1125081210253942_1803221447.xls" };
for (int i = 0; i < excelFiles.Length; i++)
{
tempbook.LoadFromFile(excelFiles[i]);
foreach (Worksheet sheet in tempbook.Worksheets)
{

newbook.Worksheets.AddCopy(sheet);
}
}

newbook.SaveToFile("result2.xlsx", ExcelVersion.Version2010);
System.Diagnostics.Process.Start("result2.xlsx");
}

Exception:
System.ArgumentException: An item with the same key has already been added.
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at Spire.Xls.Core.Spreadsheet.Collections.XlsWorkbookObjectsCollection.0(spr4614 A_0)
at Spire.Xls.Core.Spreadsheet.Collections.XlsWorksheetsCollection.1(IWorksheet A_0)
at Spire.Xls.Core.Spreadsheet.Collections.XlsWorksheetsCollection.0(String A_0, Dictionary`2 A_1)
at Spire.Xls.Core.Spreadsheet.Collections.XlsWorksheetsCollection.0(IWorksheet A_0, WorksheetCopyType A_1, Boolean A_2)
at Spire.Xls.Core.Spreadsheet.Collections.XlsWorksheetsCollection.AddCopy(IWorksheet sheet, WorksheetCopyType flags)
at Spire.Xls.Core.Spreadsheet.Collections.XlsWorksheetsCollection.AddCopy(IWorksheet sheet)
at Spire.Xls.Collections.WorksheetsCollection.AddCopy(Worksheet sheet)
at ExcelMerge.Form1.button1_Click(Object sender, EventArgs e) in C:\Users\pesho\Documents\Visual Studio 2010\Projects\ExcelMerge\ExcelMerge\Form1.cs:line 48
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

ivanski_2
 
Posts: 2
Joined: Wed Mar 28, 2018 5:32 am

Wed Mar 28, 2018 9:29 am

Hello,

Thanks for your inquiry.
If you are using the free version, please first update to the latest one(Spire.XLS Pack(Hotfix) Version:8.3.5) and try again. In case the issue still exists, please share us with your input Excel files for further investigation.

Best regards,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Thu Mar 29, 2018 5:34 am

Thanks, after update everything works.

ivanski_2
 
Posts: 2
Joined: Wed Mar 28, 2018 5:32 am

Thu Mar 29, 2018 7:10 am

Hello,

Thanks for your reply. Welcome to write to us if you encounter any other question.

Best regards,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Return to Spire.XLS