Hi,

I have Charts in Excel which are changing when we enter values in cells of Excel.

Now im writing into excel and creating image of charts using chart.ToImage but i am not getting updated charts. Charts are coming based on previous values.

 

Please Reply Soon Its Urgent

Thanks in advance

Romana tanveer

Hi,

Could you try the attached version. If you still find the issue, kindly post your template file(s), output chart image with sample code here, we will check you issue soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Amjad,

this is my Code where I am writing into excel and saving the data.

public ReturnValue UpdateInputPrice(ref DataTable dtreagent_val, string fFilePath)

{

try

{

Workbook workbook = new Workbook();

workbook.Open(fFilePath);

 

Worksheets sheets = workbook.Worksheets;

Worksheet sheet = workbook.Worksheets[1];

InputBL objBL = new InputBL();

int count = 0;

int CellValue=0;

string CellName = string.Empty;

count = dtreagent_val.Rows.Count;

for(int i=0;i<count;i++)

{

if (dtreagent_val.Rows[i]["Reagent_value"].ToString() != "")

CellValue = int.Parse(dtreagent_val.Rows[i]["Reagent_value"].ToString());

else CellValue = 0;

CellName = dtreagent_val.Rows[i]["Excel_Mapping"].ToString();

sheet.Cells[CellName].PutValue(CellValue);

}

workbook.Save(fFilePath, FileFormatType.Default);

return ReturnValue.Success;

}

catch (Exception ex)

{

TMException.LogException(ex);

return ReturnValue.Failure;

}

}

 

Now in Second method i am opening the same Excel and converting charts into iMage.

public ReturnValue ExtractExcelData(string ReportID, string fFilePath, string fXMLFilePath)

{

Workbook workbook1 = new Workbook();

workbook1.Open(fFilePath);

Worksheets sheets = workbook1.Worksheets;

ImageOrPrintOptions options = new ImageOrPrintOptions();

options.HorizontalResolution = 200;

int counter = sheets.Count;

for (int i = 0; i < counter; i++)

{

Worksheet sheet = workbook1.Worksheets[i];

int chartcount = sheet.Charts.Count;

for (int j = 0; j < chartcount; j++)

{

Chart chart = workbook1.Worksheets[i].Charts[j];

chart.PlotArea.Area.Formatting = FormattingType.None;

chart.PlotArea.Background = BackgroundMode.Automatic;

ChartArea chartarea = chart.ChartArea;

chartarea.Area.Formatting = FormattingType.Automatic;

Bitmap bitmap = chart.ToImage();

bitmap.Save(ImageFilePath + imagename + ".jpeg", System.Drawing.Imaging.ImageFormat.Jpeg);

}

}

The Chart is converted using original values not the Changed value but in Excel all graphs are changed when i opened after saving.

Please Reply Soon.

 

 

Hi,

Did you try the attached version v4.8.0.10 which I attached in my previous post. If you still find the issue, please post your generated excel file here as we want to check the conversion (chart to image) here.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Amjad,

Thanks,

But its working now, actually formulas were not getting recalculated so I use workbook.CalculateFormula(), is there any other method also?

But now i am getting another problem,

while converting charts to image some of the charts type are getting changed. I am attaching screen shot , The Chart in excel is of type Clustered Column, but its coming differently .

Thanks In Advance

Romana Tanveer

 

 

 

Hi Romana,

"But its working now, actually formulas were not getting recalculated so I use workbook.CalculateFormula(), is there any other method also?"

Well, you need to call Workbook.CalculateFormula() method if chart's source data is based on some calculated values (for the formulas) and needs to be updated when you add/update the base values. So, you will call this method before taking the image of the chart.


"while converting charts to image some of the charts type are getting changed. I am attaching screen shot , The Chart in excel is of type Clustered Column, but its coming differently ."

Please post your generated excel file containing the chart(s), we will check it soon. Also, point out which chart types are changed and not properly rendered to image file(s).

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

I am attaching excel Sheet , The Charts which are not coming properly are :

1. Chart in Sheet 2(Tube Arrival Pattern)

2. Chart in Sheet 3(Sample Arrival Pattern)

3. Chart in Sheet 10(Workload)

Thanks,

Romana Tanveer

Hi Romana,

 

Thank you for sharing the template file. We have found your mentioned issues regarding Chart2Image feature. We will look into them and get back to you soon.

 

Thank You & Best Regards,

---

Nausherwan Aslam
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

Any Updates on the issue.Looking forward to your reply as we need it urgently in our project .

Thanks & Regards,

Romana Tanveer

Hi Romana,

We will update you regarding your issue soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

You will be notified in this weekend for the latest updates regarding your issues.

Thanks for your time.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Romana,

 

Thank you for considering Aspose.

 

Please try the attached latest version of Aspose.Cells. We have fixed your mentioned issues.

 

Thank You & Best Regards,

---

Nausherwan Aslam
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

Thanks for the latest Version .

But Still I am getting problem in Data labels of one chart(see Sheet 3 - Chart Projected sample Arrival). If the digits of data label are greater than 3 , its not coming correctly while converting chartToImage().

Looking forward to your reply.

Thanks & Regards

Romana Tanveer

Hi,

Thanks for providing us the template excel file.

We have tested and found your issue as you described. Your issue has been registered to our issue tracking system (internal) with an issue id: CELLSNET-11223. As soon as we fix the issue, we will let you know about it soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

Thanks for your quick response.

 I also need 64 bit version of latest Aspose.Cells(4.8.0.11 as of now) as the server in which I have deployed the application is not working with the version provided by you.

Thanks & Regards,

Romana Tanveer