xls

  • 08 Sep

    How to use a wildcard in the excel sheet name

    Q: How to use a wildcard in the excel sheet name. I am using the below to split and convert the tabs out of a spreadsheet but every now and again the client gets the sheet name slightly wrong.

    wildcard in the excel sheet name

    Can you use a wildcard in the sheet name option?

    Example:

    2 Sticker*

    A: Added on request and available in v2023.8.12.0

    Example where we used: Page*

    wildcard in the excel sheet name

    If you need any info about this ‘wildcard in the excel sheet name’ request, please let us know.

    #excel #filetransfer #filemanagement

    Best regards,

    Limagito Team

    By Limagito-Team XLS/CSV , , ,
  • 12 Jul

    Q&A 20: I’d love the option to go the other way, csv to xls

    Q: It seems XLS as destination is meant to convert Xls as source file. I’d love the option to go the other way, csv to xls. Oh well, feature request.
    A: You are correct the original idea was to convert XLS files but on your request we added this feature request in version v2020.7.12.0

    We added some screenhosts to give you  an idea about the setup. The Source is a Windows folder:

    LimagitoX File Mover Windows Source Folder

    We added a file filter to only include *.txt and *.cvs files:

    LimagitoX File Mover File Filter

    As Destination we added our ‘Add XLS’ option:

    LimagitoX File Mover XLS as destination

    The Csv file that we are going to convert has a comma as delimiter. Our goal is to convert the Csv source file to a Xls file. We enabled ‘Change Extension’ and added .xls as ‘Extension’. File Format was set to ‘Xls, Excel 97-2000-XP-2003’.

    LimagitoX File Mover Csv To Xls optionResult:

    Limagito File Mover Csv to Xls log result

    If you need any help , please let us know.
    Regards,
    Limagito Team
    By Limagito-Team Q&A XLS/CSV ,
  • 05 May

    XLS as Destination, Part 2

    Dear users,

    v2019.5.5.0

    If you missed the first parts: https://limagito.com/xls-as-destination/

    We’ve add the following new options to the XLS(X)/CSV as Destination option.

    Sheets, delete options:

    With this option you can select which sheets you want to delete using index or name of the sheet(s). Remember, the sheet index starts at 1.

    With the setup in the screenshot below we are going to delete the sheet with index 5 AND the sheet with name ‘SheetNameToDelete’.

    Colums, delete options:

    With this option you can select which columns you want to delete on a selected sheet. The selection of the sheet is possible using index or name of the sheet. Remember, column and sheet indexes start at 1.

    With the setup in the screenshot below we are going to delete column with index 2 on sheet with index 1.

    Rows, delete options:

    With this option you can select which rowss you want to delete on a selected sheet. The selection of the sheet is possible using index or name of the sheet. Remember, row and sheet indexes start at 1.

    With the setup in the screenshot below we are going to delete row with index 1 on sheet with index 1.

    Cell Values, rename options:

    With this option you can rename cell values in rows and colmuns on a selected sheet. The selection of the sheet is possible using index or name of the sheet. Remember, row , column and sheet indexes start at 1 (value = 0 = all rows/columns).

    With the setup in the screenshot below we are going to rename all columns of the first row on sheet with index 1. The text part ‘Before’ will be replaced by ‘After’ if the cell type is ‘Text’ (String).

    Please let us know if you have any question or need help with the setup

    Regards,

    Lilmagito Team,

    Pascal

    By Limagito-Team XLS/CSV ,
1 2
SEARCH