Discrepancy Between Aspose.Cells Cloud SDK and Documentation

Aspose.Cells Cloud Product Family
1

In the middle of migrating to the new version. Having an issue with cells in which the document does not look correct. Attached are
correct.png (6.6 KB)

incorrect.png (13.7 KB)

the correct doc and the incorrect doc. Was recommended to use the PdfSaveOptions but having difficulties. Namely, all the documentation and AI tools suggest using something like

Workbook wb = new Workbook(“foo.xlxs”);
PdfSaveOptions pdfSaveOptions = new pdfSaveOptions();
ByteArrayOutputStream outputStream = new ByteArrayOutputStream
wb.save(outputStream, pdfSaveOptions);

Problem is, I cannot, for the life of me, find a single workbook that has a .save options, either Apache or yours. Am I looking in the wrong place?

2

There appears to be a discrepancy between the SDKs and the documentation. The documentation suggests that I would have the “save” method available but that is not present in the workbook that is present in the Aspose cells cloud 25.5 jar. Is this not the latest release? If so, is it possible I have some sort of trial SDK that does not contain all the methods?

3

It seems like this workbook is contained within version 25.6.

4

@sjonesi We are checking this issue.

5

It appears that I was looking at documentation for cells version 25.6. Once I downloaded that version, the discrepancy disappeared.

6

@sjonesi May I ask what library are you using? Aspose Cell Cloud?

7

Correct. 25.5 did not have the “save” method for the “workbook” class but 25.6 did. As far as I can tell, this was my fault for just not reading the documentation thoroughly enough and checking which software version I was using.

8

@sjonesi ,

We are readying Aspose.Cells Cloud 25.6 version. But we did not release the version. And we checked your provided code. This code is used by Aspose.Cells.

Please check your reference library. There are Aspose.Cells and Aspose.Cells-Cloud libraries in NuGet.

NuGet: Aspose.Cells and Aspose.Cells-Cloud

Please reference the following documents: Conversion and Save as and Save As

By the way, any needs, as long as we can fulfill them, we will complete them as soon as possible and to the best of our ability.

9

Well now, this is really confusing.

First of all, I am using Java, not C Sharp.

Secondly, I will provide the locations of the various jars I have used which should hopefully clear up this confusion.

In order to get the 25.6 version, I merely followed the documentation here. At the time it suggested version 25.6 and not 24.5.

As for the 25.5 jar, I downloaded it from this location: https://releases.aspose.cloud/java/repo/com/aspose/aspose-cells-cloud/25.5/

My thought being that if I decrement back to 25.5 by using the pom file the way the documentation is suggesting, I maybe that will fix the issue.

10

@sjonesi ,

Confirmed. The latest version is 25.5.

11

@sjonesi If you are using Java SDK 25.5, you can try the following operations to meet your needs:

CellsApi cellsApi = new CellsApi("Paste your ClientId here", "Paste your ClientSecret here");
String localFilePath = "D:/TestData/yourfile.xlsx";
String remoteFilePath = "JavaSdk/yourfile.xlsx";
String remoteName = “yourfile.xlsx”;
String newfilename= “OutResult/yourfile.pdf”;
String format = "pdf";
String storageName = "";
HashMap<String, File> uploadFiles = new HashMap<>();
uploadFiles.put("file", new File(localFilePath));
UploadFileRequest uploadRequest = new UploadFileRequest(uploadFiles, remoteFilePath, storageName);
cellsApi.uploadFile(uploadRequest);
//To Pdf
PostWorkbookSaveAsRequest request = new PostWorkbookSaveAsRequest();
request.setName(remoteName);
request.setNewfilename(newfilename);
SaveOptions saveOptions = new SaveOptions();
saveOptions.setSaveFormat(format);
request.setSaveOptions(saveOptions);
request.setFolder(remoteFilePath);
cellsApi.postWorkbookSaveAs(request);
//download pdf
DownloadFileRequest downloadRequest = new DownloadFileRequest(newfilename, "", null);
cellsApi.downloadFile(downloadRequest);
12

@sjonesi You can also try using PutConvertWorkbook to convert it to pdf:

PutConvertWorkbookRequest request = new PutConvertWorkbookRequest();
request.setLocalPath("D:/TestData/yourfile.xlsx");
request.setFormat(format);
request.setOutPath(newfilename);
request.setOnePagePerSheet= false; //The default value of this option is true, and it is recommended to set it to false.
cellsApi.putConvertWorkbook(request);
14

Decremented to 25.5 and it worked the same. Thank you.

Now I need to remove the watermark.

15

I need a license file. I have an id and an authentication key.

16

@sjonesi
If you are working on cloud, please set key as the following :

If you are using Aspose.Cells for .Net, please buy the license file in Purchase Portal

Which product are you using , Cloud API or Aspose.Cells for .Net ?

17

Cells for Java. I should not need to make any additional purchases. I attempted to use cloud in order to convert the file to PDF but the file did not look correct and I was recommended to convert it locally.

18

@sjonesi ,

Could you provide the test Excel file so we can check what is preventing us from meeting your needs?

19

Perhaps cells and cloud-cells are two separate products and my company only has license for one.

20

@sjonesi
If you are trying Aspose.Cells for Java, please post your issue in Aspose.Cells Product Family - Free Support Forum - aspose.com

21

I should have another thread there I can use. Thank you.