XLS/CSV Archives - File transfer tool from Limagito

28 Jan
How to convert excel and csv files to pdf
Q: We need a way to convert excel and csv files to pdf. Can this be done using Limagito File Mover.
A: Yes this is possible using our XLS as Destination option (with recent versions of Limagito File Mover, v2026.1.27.0 and up)
In our example we used a Windows Folder as Source. In this folder we’ll be able to drop almost any kind of image file type and it will be converted to pdf.
We’ve set a timer to scan this folder every 30 seconds:
Function is set to Move, so after a successful conversion the source file will be deleted. If you want to keep the source files, leave the function to ‘Copy Files’ and enable our ‘File Memory’ option to prevent us converting the same source file over and over again.
As Destination we added our [XLS] option
Set the destination for the converted xls / csv files
Switch to PDF tab and enable ‘Export to Pdf’
Autofit Columns will adjust the columns so all cell/csv field values will be fully visible in the pdf
Autofit Column Adjustment will add some extra space between the Columns (100 = 100%)
Print To Fit
When ‘enabled’ you can use:
Number Of Horizontal Pages
Number Of Vertical Pages
When ‘disabled’ you can use:
Print Scale (100 = 100%)
Don’t forget to Enable the Rule after your setup so it will start scanning
If you need any help about this ‘week number from filename’ question, please let us know.
Best Regards,
Limagito Team
#xls #pdf #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team PDF XLS/CSV convert csv, convert excel, convert to pdf
12 Oct
Excel as destination losing some rows of data when converting from csv
Excel as destination losing some rows of data when converting from csv
Q: We are running LimagitoX File Mover v2024.1.20.0 and noticed an issue with the Excel destination. It appears to be losing some rows of data starting after line 45. You can replicate this issue by creating a simple rule that uses the attached test_file.txt file as the source and set the destination as Excel with the options in the images below. Note that the text input file has 101 rows, and the Excel output file only has 57. We are still seeing this issue with version 2024.8.26.0. Didn’t want it to fall off your radar.
A: We added the following Pascal Script which will convert your source Ansi csv file to Unicode.
Open our Pascal Script option:
Enable and Add the following ‘On Destination’ Pascal Script:
Begin psExitCode:= 1; // ... add your code here psChangeTxtEncoding(psFilePath + psFileName, psFilePath + psFileName, 2); End.
This will adjust the source txt file so if you don’t want this, add an extra Rule where you use a copy of the original file.
Feedback Customer: That fixed it. Thank you!
If you need any help with this ‘send an email when a file is successfully transferred’ request, please let us know.
Best Regards,
Limagito Team
#xls #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team XLS/CSV excel, losing rows, xls
19 Feb
How to copy a csv file when a specific row exists
How to copy a csv file when a specific row exists
Q: My client is looking for advanced file copy functionality and have set of requirements for this process. Appreciate if you can clarify below requirements applicability with Limagito. The file copying should not copy the currently modified csv files. Basically, the only difference in the files that are completed and in “modify” mode is a last row in the file – If this specific row not exists, file still in “modify” mode.
A: Yes this is possible. We added two examples (scripts) on how to achieve this.
1. Example 1: will read the csv file and check all rows for a certain keyword
2. Example 2: will read the csv file and will only check the last row for a certain keyword
We used a windows folder as source:
Open our ‘Pascal Script’ option:
Example Script 1 will read the csv file and check all rows for a certain keyword ( RT_Count )
Please enable and add the following ‘On Destination’ Pascal Script: link
You can adjust the Keyword but always in Uppercase
Example Script 2 will read the csv file and will only check the last row for a certain keyword ( RT_Count )
Please enable and add the following ‘On Destination’ Pascal Script: link
You can adjust the Keyword but always in Uppercase
As Destination we also used a windows folder:
RunTime Log Result:
If you need any help with this ‘copy files in a specific order’ request, please let us know.
Best Regards,
Limagito Team
#csv #managedfiletransfer #filetransfer #filemanagement
By Limagito-Team Pascal Script XLS/CSV row exists, specific row