Yes, I was providing the extension as ‘.xlsx’, but what I was writing was not Excel. Then I took a step back, started looking at it from different point of view and it struct me. I did try that but that did not work either. I did find few more discussions like below, but none with a satisfactory outcome and also some of them were very old.Ĭreate XLS file on Application Server (no tab-delimited format) | SAP CommunityĬreate excel file on application server | SAP CommunityĪt this point, I was convinced that I should now try to convince the user who requested this to use. Writing Excel file into Application Server using horizontal tab | SAP Blogsīut this method did not work for me. I did find below which says you can do this with using tabs. I also searched over SAP blogs for some help.
The problem is, Excel does not open this file and simply says, it is not Excel file. ProcessĪt first, I thought its very simple. The first thing I did – created a tab separated file with ‘.xlsx’ extension.
This post explains how I reached to a solution and how to code the solution. I recently got a requirement to write a file on application server in excel format.