Please guide me for using aspose-cells-cloud/aspose-cells-cloud-php
We have fixed the example on the readme document of GitHub.
Thank you for your support.
I have converted XLSM to pdf from your online portal, its giving proper output. CITY 1.5 SV MT(i-VTEC)_150262.pdf (30 KB)
While I am converting XLSM to pdf I am not getting proper pdf output. Its little bit align to right side and also no bottom margin download (1).pdf (80.7 KB).
I am using aspose-cells-coud-php sdk for conversion.
My code is below :
require_once(‘vendor\autoload.php’);
use \Aspose\Cells\Cloud\Api\LightCellsApi;
class Workbook {
public $cells;
public function __construct() {
$this->cells = new LightCellsApi( 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX','XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',"v3.0",'https://api.aspose.cloud/');
}
public function runCloudAPI() {
$DataSource ='CITY 1.5 SV MT(i-VTEC)_150262.xlsm';
$AssemblyTest ='assemblytest.xlsx';
$sourcePath = ".\\data\\";
$files = array (
$DataSource => $sourcePath.$DataSource
);
$result = $this->cells->postExport($files, 'workbook','pdf' );
// print_r($result['files'][0]);
$pdf_content=$result['files'][0]['file_content'];
$pdf_name=$result['files'][0]['filename'];
$pdf_decoded = base64_decode ($pdf_content);
//Write data back to pdf file
$pdf = fopen ('test.pdf','w');
fwrite ($pdf,$pdf_decoded);
//close output file
fclose ($pdf);
//$this->cells->assertNotNull($result);
}
}
$workbook = new Workbook();
$workbook->runCloudAPI();
@dev12scube,
A default parameter of the Cloud API export PDF format is different from the online portal. We suspect this is the cause of your problem.
Please provide your original documents, we will further confirm.
I am converting xlsm file to pdf. File is attached. CITY 1.5 SV MT(i-VTEC)_150262.zip (63.1 KB)
Converted from online portal CITY 1.5 SV MT(i-VTEC)_150262 (3).pdf (75.4 KB) . I have checked pdf properties it showing “8.50 × 11.00 in (portrait)”
Converted from php sdk aspose_2022-04-07 162550.pdf (80.7 KB) . I have checked pdf properties it showing ''Page size:Varies"
We had tested your provided file and have noticed the reported exception. So logged a ticket CELLSCLOUD-11486 in our issue tracking system for further investigation and resolution. We will notify you as soon as it is resolved.
Can I know how much time it will take to resolve that issue ?
@dev12scube,
We plan to release Aspose Cells Cloud 22.4 next week.
The version will solve the issue.
Okay. Thanks for quick response.
We fixed the issue on the QA server. Please check if the export file (TestCustom_11486.pdf (81.0 KB)) meets your needs.
Yes. Above pdf meeting my expectations.
I have tried it. Its working when I am converting workbook to pdf. But when I am converting worksheet to pdf its showing same issue. Sample pdf CITY-worksheet.pdf (60.2 KB)
@dev12scube,
I think it should be a similar problem, we will check and solve it as soon as possible.
Please let know us when it got resolved.
I have checked it.
This sample is generated by using workbook.CITY-Workbook.pdf (81.0 KB)
This sample is generated by using worksheet CITY-Worksheet Latest.pdf (60.2 KB)
Still there is issue in pdf. Text below certificate title is cutting CONFORMITY OF PRODUCTION.
You can see in CITY-Worksheet Latest pdf.
I am using next xlsm file for pdf conversion. CITY 1.5 SV MT(i-VTEC)_150262 (1).zip (63.1 KB)
We checked your provided files and found the reason for the issues. So logged the new ticket CELLSCLOUD-11544 in our issue tracking system for further investigation and resolution. We are fixing the issue on the QA server. Please check if the exported file (51.0 KB)
meets your needs.
Yes. Above file meeting my expectations.