We're sorry AsposeCloud doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.cloud

Final file missing when converting html to excel using On Premise

I am making below axios call for on Premise approach:

let data = new FormData();
        let randomStr = Math.random().toString(36).slice(2, 8);
        let outputFileName=`output-${randomStr}.xlsx`;
        let outputDatafolder = 'htmlToExcelFilesData';
        let outputFilePath = outputDatafolder + '/' + outputFileName;
        data.append('file', htmlStream);
        let accessToken = await getAsposeAccessToken();
let configuration = {
            method: 'put',
            url: config.getConfig('ASPOSE_BASE_URL') + '/v3.0/cells/convert?format=XLSX&outPath=' + outputFilePath + '&checkExcelRestriction=true&streamFormat=html',
            headers: {
                'accept': 'multipart/form-data',
                'authorization': 'Bearer '+ accessToken,
                'Content-Type': 'multipart/form-data',
                'x-aspose-client': 'Containerize.Swagger',
                ...data.getHeaders()
            },
            data: data
        }

I am getting below successful response:

{
  FileInfo: {
    Name: 'output-09ov32.xlsx',
    Size: 9255,
    Folder: 'htmlToExcelFilesData'
  },
  Code: 200,
  Status: 'OK'
}

But I am not able to find converted file in my azure storage account file share. I am not able to find it in my mounted folder in pod as well.

Please also note that I am already using aspose on Premise for conversion of excel to pdf and was getting converted files in azure file share. So ideally, this converted file should also be present in that file share right?

@rajatdpw,

According to the code you provided, we conducted a simulated test using C# and found the corresponding file in Aspose Cloud storage.

Please take a moment to check your Aspose Cloud storage to see if you can locate it. Additionally, kindly provide your account email. We will search the system logs for further relevant information.

Hi @wangtao Please find email id:

jayakrishna_alwar[at]dpworld.com

Please note that I checked my storage account where cloud api is storing converted files, as well as file share which is mounted for on premise approach. I wasn’t able to find the file. Also, Can you kindly share how are you calling on premise api, like I can use it for reference.

Also, please share if any configuration is required to be set.

@rajatdpw,

We do not find data with your provided email. Please check your provided email.

Please use jayakrishna.alwar[at]dpworld.com

Sorry for the confusion

@rajatdpw,

Okay, we got the log data and we will go to check.

@rajatdpw,

Please refer to the following code. and try to use Aspose.Cells Cloud SDK for Node to test the conversion case.

const clientId = process.env.CellsCloudClientId;
const clientSecret = process.env.CellsCloudClientSecret;
const ApiURL = process.env.CellsCloudApiBaseUrl;
const localPath = “TestData/”;
var fs = require(‘fs’);
var path = require(‘path’);
var assert = require(‘assert’);
describe(‘Conversion test’, function() {

  this. Timeout(200000);
const cellsApi = new api.CellsApi(clientId, clientSecret,"v3.0",ApiURL);
describe('convert html to xlsx test', function(){
  it("should call PutConvertWorkbook successfully" , function(){
    var remoteFolder = "htmlToExcelFilesData/"
    var localName = "ToxXlsx.html"
    var remoteName = "output-fje5tj.xlsx"
    var format = "html"
    var mapFiles = {};           
    mapFiles[localName]= fs.createReadStream(localPath  +localName) ;
    var request = new model.PutConvertWorkbookRequest();
    request.file =  mapFiles;
    request. Format = "xlsx";
    request.streamFormat =  format;
    request.outPath = remoteFolder + remoteName;
    return cellsApi.putConvertWorkbook(request).then((result) => {
        expect(result.response.statusCode).to. Equal(200);
    });
  });
}); 

});

The following figure shows the running structure:

And you can check your Cloud API run details with Fiddler.

Hi @wangtao. We are leveraging on Premise approach for file conversion. Cloud api is anyways working but there is latency issue. Which is why we are using aspose.cells docker image.

@rajatdpw,
Thank you for choosing Aspose.Cells, and you can also refer to Aspose.Cells Cloud Docker.

@wangtao We have been already using on Premise approach (using cells docker image) for excel to pdf conversion. That is working fine, like we are getting converted files in azure file share, which is mounted in pv-yaml file.

The main issue while converting html to excel is, i am getting a successfull message as shown above in first message, but file is not present in location.I was wondering if you could kindly help something in this regard. Thank you for your support so far

@rajatdpw,

From your code parameters and response, the file should be in the "htmlToExcelFilesData“ folder of the Aspose Cloud default storage space.

Yes. Ideally it should be. Can you confirm like if I am getting below response, does that mean file conversion has happened?

    {
  FileInfo: {
    Name: 'output-09ov32.xlsx',
    Size: 9255,
    Folder: 'htmlToExcelFilesData'
  },
  Code: 200,
  Status: 'OK'
}

Because, If you see my request body in first message, I am sending data as htmlStream in form data as:

let data = new FormData();
data.append('file', htmlStream);

I even tried with, data.append(‘document’, htmlStream) and I got same response. I am not sure how the api is behaving in both the cases. can you confirm?

@rajatdpw,

In theory, if you receive the above response, it indicates that the file conversion was successful.
There are two ways we can parse the FormData data you added, and typically, we determine the input file type based on the query parameter “streamFormat.”

Hi @wangtao. Considering I am getting a correct response but file is not present at expected location, I think problem is that I am not giving storageName in query params as shown in the swagger UI:

image.jpg (339.8 KB)

Can you please help me, like as per our last discussion in this chat: link , I am giving storageName as ‘First Storage’.

Rest is all same like there is a json file at mounted path with same configuration. Can you please let me know if anything needs to be done here.

PS: I tried by giving storageName as ‘File Storage’ , still no luck :frowning:

@rajatdpw,

This is a strange issue.
I will create a ticket number for it. And I’ll simulate the way you mentioned handling problem occurrences.
I wish I could reproduce this issue.

1 Like

@rajatdpw
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSCLOUD-12348

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.