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.

Tue Nov 17, 2015 1:27 pm

I am trying to load an excel sheet in WorkBook, but it gives exception as

System.NotImplementedException: rgbColor

Code: Select all
 public Workbook CreatePivotTable(Stream filestream)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromStream(filestream);
            Worksheet sheet = workbook.Worksheets[0];
            sheet.Name = "Customers";


Below is my snap of error, I am getting in UI.

I have tried loading the fileform path aslo but got the same error,

Please find my attachment of excel sheet.

Any help would be appreciated.
Thanks
Attachments
SpireXlsError.PNG
SpireXlsError.PNG (50.74 KiB) Viewed 4375 times
FileName.zip
Sample Excel Sheet
(75.09 KiB) Downloaded 320 times

vijaypratap
 
Posts: 1
Joined: Sat Nov 14, 2015 10:52 am

Wed Nov 18, 2015 2:38 am

Hi,

Thanks for your inquiry.
I have recreated your issue, sorry for the inconvenience caused by the issue. I have forwarded it to our dev team. We will inform you when it is resolved.

Best Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Tue Nov 24, 2015 8:08 am

Hi,

The issue has been resolved. Our test team is building a new version. We will provide you with it as soon as possible.

Best Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Fri Dec 11, 2015 2:34 am

Hi,

Thanks for waiting.
New version has been released. Welcome to download and test Spire.XLS Pack Hotfix Version:7.8.64.

Best Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Tue Dec 15, 2015 6:35 am

Hi,

Has your issue been resolved?
Thanks for your feedback.

Best Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Tue May 09, 2017 8:26 am

Hello,

We are pursuing a product which will help us in copying tabs from an excel worksheet to another worksheet
To have a POC on the same, we are trying out the free version of Spire.xls.
While doing this, I am getting rgbColor exception. I read it from the previous posts in this topic that, the issue was fixed in Spire.XLS Pack Hotfix Version:7.8.64.
When I checked the Spire.XlS dll of free version I am using, I see that it is of 7.9.0.55040
Since I am using a higher version, isn't it supposed to work fine for me? Is there something else I have to do to make this working?

We are worried if this problem is still present even in the paid version of Spire.xls, we might not be able to integrate Spire to our application.
Can you please clarify this?

Thanks,
Roopesh

roopeshvp@gmail.com
 
Posts: 15
Joined: Thu May 04, 2017 6:50 am

Tue May 09, 2017 8:41 am

Dear Roopesh,

Thanks for your inquiry.
Please provide us with your input file and the code you were using for testing. Then we will investigate it and update to you ASAP.

Thanks,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue May 09, 2017 10:58 am

Hi,

Thank you for responding.
Here is the code-
I get the rgbcolor error with the invent.xlsx file. Just to make out some inference from the error, I removed all formatting from invent.xlsx and then it worked fine. But in my real production scenario the file will have formatting like the one attached and it fails.

Code: Select all
                Workbook newbook = new Workbook();
                newbook.Version = ExcelVersion.Version2010;
                newbook.Worksheets.Clear();

                DirectoryInfo d = new DirectoryInfo(@"F:\File_Copy");
                Workbook tempbook = new Workbook();
                string[] excelFiles = new String[] { "copy.xlsx","invent.xlsx" };
                for (int i = 0; i < excelFiles.Length; i++)
                {
                    string file=d.FullName+"\\"+excelFiles[i];
                    string test;
                    tempbook.LoadFromFile(file);
                    foreach (Worksheet sheet in tempbook.Worksheets)
                    {
                        newbook.Worksheets.AddCopy(sheet);
                    }
                }
                newbook.SaveToFile(d.FullName + "\\" + "result.xlsx", ExcelVersion.Version2010);

roopeshvp@gmail.com
 
Posts: 15
Joined: Thu May 04, 2017 6:50 am

Tue May 09, 2017 11:03 am

Though I have uploaded excel file in the last post, I am unable to see it online.
Can you please let me know if you see the attachment and if I am not looking at the right place?

roopeshvp@gmail.com
 
Posts: 15
Joined: Thu May 04, 2017 6:50 am

Wed May 10, 2017 1:34 am

Hi,

Many thanks for the information.
Sorry that there is no attachment, please upload again the files which have that issue here, or send them to us(support@e-iceblue.com) via email.

Thanks,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Wed May 10, 2017 4:09 am

Hi Besty,
Attached is the file which gives me error.

Thanks,
Roopesh

Betsy.jiang wrote:Hi,

Many thanks for the information.
Sorry that there is no attachment, please upload again the files which have that issue here, or send them to us(support@e-iceblue.com) via email.

Thanks,
Betsy
E-iceblue support team
Attachments
invent.zip
(9.22 KiB) Downloaded 285 times

roopeshvp@gmail.com
 
Posts: 15
Joined: Thu May 04, 2017 6:50 am

Wed May 10, 2017 6:31 am

Dear Roopesh,

Thanks for the file.
I have tested the file and the code you provided with the latest Spire.XLS Pack Hotfix Version:7.12.11, it worked fine on my side. Please try to use this version.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Wed May 10, 2017 11:20 am

Thank you so much Betsy. I am trying this right away.

roopeshvp@gmail.com
 
Posts: 15
Joined: Thu May 04, 2017 6:50 am

Wed May 10, 2017 2:46 pm

Hi Betsy,
You are the Best!!.
It is working fine with the dlls you have provided.
Can you tell me what would have gone wrong with the earlier version of dlls that I was using?

Thanks,
Roopesh

roopeshvp@gmail.com
 
Posts: 15
Joined: Thu May 04, 2017 6:50 am

Thu May 11, 2017 9:24 am

Dear Roopesh,

Thanks for your feedback.
The issue is caused by nonstandard XML data in your original file, and the latest version has fixed it by improving the compatibility in this aspect.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS