Ufdjrw

Rewrite the power sum in terms of convolution

Solar Charging Car Battery through Cigarette Lighter Outlet?

How to save the initial startup configuration in IOS XR?

'The literal of type int is out of range' con número enteros pequeños (2 dígitos)

Do items de-spawn in Diablo?

cat shows nothing

They call me Inspector Morse

Why does liquid water form when we exhale on a mirror?

How to draw cubes in a 3 dimensional plane

What does "promotional consideration" at the end credits mean?

Signed and unsigned numbers

Why doesn't this Google Translate ad use the word "Translation" instead of "Translate"?

Should I take out a loan for a friend to invest on my behalf?

Error during using callback start_page_number in lualatex

How strictly should I take "Candidates must be local"?

Has a sovereign Communist government ever run, and conceded loss, on a fair election?

List elements digit difference sort

Could you please stop shuffling the deck and play already?

What problems would a superhuman have whose skin is constantly hot?

I reported the illegal activity of my boss to his boss. My boss found out. Now I am being punished. What should I do?

Why the color red for the Republican Party

Why would one plane in this picture not have gear down yet?

What are the practical Opportunty Attack values for a bugbear, holding a reach weapon, with Polearm Mastery?

Find longest word in a string: are any of these algorithms good?

pass xlsx file to angular js

0

I'm trying to pass an xlsx file that I generated in php with the excelphp library, to my frontend that is in angular js. To download the file I am using the angular file saver library. All this works correctly, the problem is that I can not open the file, it indicates that it is corrupt.

this is my php code for send response type:

$response = new Response();
 $response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
 $response->headers->set('Content-Disposition', 'attachment;filename="' . $fileName . '"');
 $response->headers->set('Cache-Control', 'max-age=0');
 $response->headers->set('Cache-Control', 'max-age=1');

 $response->headers->set('Cache-Control', 'cache, must-revalidate');
 $response->headers->set('Pragma', 'public');
 $response->headers->set('Access-Control-Allow-Origin', '*');

 $response->prepare($request);
 $response->sendHeaders();
 ob_end_clean();
 $objWriter->save('php://output');
 exit();

this works perfectly.

this is my angular js code:

const file = await service.exportExcel(itemId);

const blob = new Blob([file], type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

 FileSaver.saveAs(blob, "Export.xlsx");

this download the file perfectly, but this is the content generated:

what is the problem here?

php angularjs excel filesaver.js

share|improve this question

asked Mar 6 at 15:15

kmilo93sdkmilo93sd

95110

add a comment | 

0

I'm trying to pass an xlsx file that I generated in php with the excelphp library, to my frontend that is in angular js. To download the file I am using the angular file saver library. All this works correctly, the problem is that I can not open the file, it indicates that it is corrupt.

this is my php code for send response type:

$response = new Response();
 $response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
 $response->headers->set('Content-Disposition', 'attachment;filename="' . $fileName . '"');
 $response->headers->set('Cache-Control', 'max-age=0');
 $response->headers->set('Cache-Control', 'max-age=1');

 $response->headers->set('Cache-Control', 'cache, must-revalidate');
 $response->headers->set('Pragma', 'public');
 $response->headers->set('Access-Control-Allow-Origin', '*');

 $response->prepare($request);
 $response->sendHeaders();
 ob_end_clean();
 $objWriter->save('php://output');
 exit();

this works perfectly.

this is my angular js code:

const file = await service.exportExcel(itemId);

const blob = new Blob([file], type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

 FileSaver.saveAs(blob, "Export.xlsx");

this download the file perfectly, but this is the content generated:

what is the problem here?

php angularjs excel filesaver.js

share|improve this question

asked Mar 6 at 15:15

kmilo93sdkmilo93sd

95110

add a comment | 

I'm trying to pass an xlsx file that I generated in php with the excelphp library, to my frontend that is in angular js. To download the file I am using the angular file saver library. All this works correctly, the problem is that I can not open the file, it indicates that it is corrupt.

this is my php code for send response type:

$response = new Response();
 $response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
 $response->headers->set('Content-Disposition', 'attachment;filename="' . $fileName . '"');
 $response->headers->set('Cache-Control', 'max-age=0');
 $response->headers->set('Cache-Control', 'max-age=1');

 $response->headers->set('Cache-Control', 'cache, must-revalidate');
 $response->headers->set('Pragma', 'public');
 $response->headers->set('Access-Control-Allow-Origin', '*');

 $response->prepare($request);
 $response->sendHeaders();
 ob_end_clean();
 $objWriter->save('php://output');
 exit();

this works perfectly.

this is my angular js code:

const file = await service.exportExcel(itemId);

const blob = new Blob([file], type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

 FileSaver.saveAs(blob, "Export.xlsx");

this download the file perfectly, but this is the content generated:

what is the problem here?

php angularjs excel filesaver.js

share|improve this question

asked Mar 6 at 15:15

kmilo93sdkmilo93sd

95110

$response = new Response();
 $response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
 $response->headers->set('Content-Disposition', 'attachment;filename="' . $fileName . '"');
 $response->headers->set('Cache-Control', 'max-age=0');
 $response->headers->set('Cache-Control', 'max-age=1');

 $response->headers->set('Cache-Control', 'cache, must-revalidate');
 $response->headers->set('Pragma', 'public');
 $response->headers->set('Access-Control-Allow-Origin', '*');

 $response->prepare($request);
 $response->sendHeaders();
 ob_end_clean();
 $objWriter->save('php://output');
 exit();

const file = await service.exportExcel(itemId);

const blob = new Blob([file], type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

 FileSaver.saveAs(blob, "Export.xlsx");

share|improve this question

asked Mar 6 at 15:15

kmilo93sdkmilo93sd

95110

share|improve this question

asked Mar 6 at 15:15

kmilo93sdkmilo93sd

95110

asked Mar 6 at 15:15

kmilo93sdkmilo93sd

95110

asked Mar 6 at 15:15

kmilo93sdkmilo93sd

95110