Is it possible to do the following ?

[lijgeorge]

Hi Team,

Content like Excel Table, Image, Chart, Pivot Table can be copied as Table, Image, Chart, Pivot Table to PPT

Excel to PPT

[list=]Excel Chart to PPT Chart
Excel Table to PPT Table
Excel Pivot Table to Pivot Table
Excel Image to PPT Image[/list]

PPT to Excel

[list=]PPT Slide Table to Excel Table
PPT Slide Chart to Excel Chart
PPT Slide Image to Excel Image
PPT Slide Pivot Table to Excel Pivot Table[/list]

[Brian.Li]

Hello,

Thanks for your inquiry.
In fact, PPT document does not contain the pivot table object. Regarding the PPT Slide Pivot Table you mentioned, could you please provide a sample PPT file for our reference? As for your other requirements, please refer to the attached code.
If there are any problems during the test, please provide your input files for further investigation. You can send them to us via email (support@e-iceblue.com). Thanks in advance.

Sincerely,
Brian
E-iceblue support team

[lijgeorge]

Hi Brian,

Thank you for sharing the code.

While implementing the code, we have got an error.

Code: Select all

for (int j = 0; j < chart.DataRange.Rows[i].CellList.Count; j++)

Error

Error CS1061 'CellRange' does not contain a definition for 'CellList' and no accessible extension method 'CellList' accepting a first argument of type 'CellRange' could be found (are you missing a using directive or an assembly reference?) ExcelToPPT POC C:\Users\lijgeorge\source\repos\ExcelToPPT POC\ExcelToPPT POC\Program.cs 218 IntelliSense Active Compiler

Current Spire Office Version:

.nuget\packages\freespire.office\4.3.1

[Brian.Li]

Hello,

Thanks for your inquiry.
I am sorry that the free version does not define this property. Please use the code below instead.

Code: Select all

CellList -> Cells
CellList.Count -> CellsCount

At the same time, the free version does not support getting pictures in Excel files. And we only update the free version irregularly. If you need to use this feature, please directly use our commercial version (the latest version is Spire.Office Platinum(Hotfix) Version:6.7.0).

Sincerely,
Brian
E-iceblue support team

[lijgeorge]

Hi Brian,

Code :

Code: Select all

 IChart pptChart = slide.Shapes.AppendChart(ChartType.BarClustered, rect1, false);
                for (int i = 0; i < chart.DataRange.Rows.Length; i++)

Issue

chart.DataRange is null

Files Attached
Source Excel
Error Screen

Question :

Is there any option to copy the Charts and Tables as is without remapping the properties, like copy paste feature using Clipboard in Windows.

[Brian.Li]

Hello

Thanks for your feedback.
Regarding the issue “chart.DataRange is null”, I tested your case and did reproduce your issue. I have logged it in our bug tracking system with the ticket SPIREXLS-3378. We will let you know as there is any update.
As for using the clipboard to copy and paste charts and tables in Windows, I am sorry that our Spire.Office does support similar features. Apologize for the inconvenience caused.

Sincerely,
Brian
E-iceblue support team

[lijgeorge]

Hi Brian,

I hope you are doing well.

Kindly let me know the update on above request ?

Thank You
Lijo George

[Brian.Li]

Hello Lijo,

Thanks for your follow up.
I just communicated with our developers and learned that this issue is caused by that the chart in your worksheet is a composite chart, and the data source is not continuous, it is actually not possible to get the data range. You can use Microsoft Excel to view the data range of the chart (Right click the chart -> Select Data), you will find that the data range is empty. Our Spire.XLS is based on Microsoft Excel. I'm sorry that there is no way to solve this issue. Hope you can understand and apologize for the inconvenience caused.

screenshot.png (49.98 KiB) Viewed 3363 times

Sincerely,
Brian
E-iceblue support team

[lijgeorge]

Hi Brian,

Could you confirm if grouped objects like Charts, Images can be converted in Image using Spire.

I am able to convert individual chart or image to image, but not able to find grouped images or charts.

Thank You
Lijo George

[Brian.Li]

Hello Lijo,

Thanks for your inquiry.
I am sorry that our Spire.XLS does not yet support the feature you mentioned. But I have added it as a new feature into our upgrade list with the ticket SPIREXLS-3392. Once it is achieved, we will let you know. Apologize for the inconvenience caused.

Sincerely,
Brian
E-iceblue support team

[lijgeorge]

Hi Brian,

I am looking to get Table data using Table name from an Excel Sheet to Image and Copy Table content to another sheet .

Kindly help me out .

Thank You
Lijo George

[Brian.Li]

Hello Lijo,

Thanks for your inquiry.
Please refer to the following code to meet your needs.

Code: Select all

            Workbook workbook = new Workbook();
            workbook.LoadFromFile("test.xlsx");

            INamedRange namedRange = workbook.NameRanges.GetByName("Your table name");
            CellRange range = namedRange.RefersToRange as CellRange;
            IWorksheet srcWorksheet = range.Worksheet;

            srcWorksheet.SaveToImage(range.Row, range.Column, range.LastRow, range.LastColumn).Save("image.png", ImageFormat.Png);

            Worksheet targetWorksheet = workbook.Worksheets.Add("target");
            range.Copy(targetWorksheet.Range[range.Row, range.Column, range.LastRow, range.LastColumn]);

            workbook.SaveToFile("result.xlsx",ExcelVersion.Version2016);

If this cannot help you, please provide your input file and your desired output for further investigation. You can send them to us (support@e-iceblue.com) via email, thanks in advance.

Sincerely,
Brian
E-iceblue support team

[Brian.Li]

Hello Lijo,

Greetings from E-iceblue!
Glad to inform you that we just released Spire.XLS Pack(Hotfix) Version:11.9.2 which supports converting grouped Charts and grouped Images to an Image, please download it from the following links to test on your side. Looking forward to your test result.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.XLS/11.9.2

The sample code as below.

Code: Select all

List<Bitmap> images = sheet.SaveShapesToImage(new SaveShapeTypeOption());
for (int i = 0; i < images.Count; i++)
{
    images[i].Save(string.Format(outputFile + "Bug_3392_1-{0}.png", i), ImageFormat.Png);
}

Sincerely,
Brian
E-iceblue support team