Free Support Forum - aspose.com

Pivot table data lost in case of mail attachment

hi

we are sending the generated excel file to the clients through mail.

now when the client clicks the open in file dialog box. it will open the excel and there is no data for pivot excel table.

here the attachement request will be get.

how to fix this one.



you said that request for pivot table generating should be post.

if we give the request as get. we did not get the data in pivot table.

any comment on this.

Thanks & regards

Ranjith.


Hi,

Please provide us your simple source code and source templates (input xls/xlsx files if any) so that we could look into it and help you asap.

hi

follow the steps:

i executed your one of demo program.


aspose-cells-2.5.2-java\samples\webDemo\src\PivotTable

find the attached code file and generated xlsx file.

send this file as mail attachment.(without opening and save back to the disk).

it is working fine firefox.

when i open the file in internet explorer. the pivot table data is not displayed.

we found one thing.

after saving to the disk location open the excel file save back to the disk.

and send this file as attachment. in this case it works in internet explorer. and file size is also increased.

Thanks & Regards.

Ranjith.







Hi,

Please try the following code after creating the pivottable:

pivotTable.calculateData();

hi

the given method is works only for that example.

we are using lightcelldataprovider.

this is my another example.


import java.io.IOException;

import com.aspose.cells.*;
public class pivot {
public static void main(String[] args) throws Exception {
Workbook workbook = new Workbook();
workbook.open(“c:\5315.xlsx”,FileFormatType.XLSX);
pivot p=new pivot();

p.CreateStaticReport(workbook);

//Saving the Excel file
workbook.save(“c:\mail.xlsx”,FileFormatType.XLSX);
}

private void CreateStaticReport(Workbook workbook)
{
Worksheets worksheets = workbook.getWorksheets();
Worksheet worksheet = worksheets.addSheet(“Pivot sheet”);

PivotTables pivotTables = worksheet.getPivotTables();

//Adding a PivotTable to the worksheet
int index = pivotTables.add("=Data!$A$1:Y$73",“A1”,“PivotTable1”);

//Accessing the instance of the newly added PivotTable
PivotTable pivotTable = pivotTables.get(index);

//Unshowing grand totals for rows.
pivotTable.setRowGrand(false);

//Draging the first field to the row area.
pivotTable.addFieldToArea(PivotFieldType.ROW,“Applicant Status”);

//Draging the second field to the column area.
pivotTable.addFieldToArea(PivotFieldType.PAGE,“Vacancy Name”);
pivotTable.addFieldToArea(PivotFieldType.PAGE,“Recruiter Full Name”);
pivotTable.addFieldToArea(PivotFieldType.PAGE,“Address City”);



//Draging the third field to the data area.
pivotTable.addFieldToArea(PivotFieldType.DATA,“Applicant Number”);

PivotFields pivotFields = pivotTable.getDataFields();
pivotFields.get(0).setFunction(ConsolidationFunction.COUNT);

pivotTable.setAutoFormatType(PivotTableAutoFormatType.REPORT1);

pivotTable.calculateData();


}

}

i execute this one and sent as mail attachment.

in this case also pivot table table data is lost.it is happens only in internet explorer.

how to fix this one.

please find the attached excel.

thanks & regards.

Ranjith.


hi

any update on this?

Thanks & Regards

Ranjith.

Hi,


We could not find this issue, it works fine, the output file is attached here. Please give your output file here. We will check it soon.
Thanks.

hi

steps:

1.send xlsx file as mail attachement
2.open this xlsx file in internet explorer 6.0
3.click open in dialog box.

please test this case in internet explorer.

please find attached images

Hi,


Well, we could not find such kind of issue you mentioned. We have tested both on web page and via mail attachment. We have no good idea for your issue which seems strange to us. We think you should try to create such a file manually in MS Excel and see whether it can work fine for you when sending the file as mail attachment.

Thank you.