i have been advised to ask about my problem here. i have an xlsx worksheet with uk and cyprus phone numbers on including the dialing code, without the 00 and just a +. when i save as csv all looks ok however when i open it again i get random numbers with +11 in in the UK numbers only. i have spent 3 days reading and watching videos and tried many ways of formatting it but clearly i have missed something as i cant sort it. any help and advice is greatly appreciated. Thanks
I tried calamine but the csv produced by calamine is not valid. I generated several csv files from xlsx files using the code provided by calamine in one of there examples but when I try to verify the resultant csv files using different online tools, these files were identified as having some error.
Actually, I wanted to manipulate some xlsx files using polars. Since polars does not support xlsx files manipulation directly, I will first convert these xlsx file to csv will do necessary manipulation and will than convert the modified csv files back to xlsx files.
We are trying to convert an excel file with about 70000 rows to dmn decision table. Based on this article, Converting Excel Worksheets to DMN Camunda we picked up convertor-dmn-xlsx-cli binary and tried to use it. When the number of rows in excel file are small, things work fine. Once it goes past about 1000 rows, things take hours to complete and also we are sometimes unable to complete the process. In addition, decision table with large number of rows takes a very long time to load in DMN embedded engine.
lets say on C:/ and i am using GUI upload and download FM which is upoloading and downloading but downloaded files are opening though i have installed converter at my end. Kindly provide alterantive FM to input .XLSX file in SAP and download the same on Server
Quick refresher: a .xls file stores spreadsheet data in a single binary file. But a .xlsx file is based on the Open XML format, and stores data as separate files and folders in a compressed ZIP package.
Inspired by this question: Using external tables in TikZ, I would like to know whether it is technically possible to use a xlsx (Office Open XML) file directly with luaLaTeX, i.e. can luaLaTeX call some external unzip program and then parse the extracted XML file? Or is that pushing the envelope too hard?
I am hoping to use RStudio to automatically read the most recent .txt file from the folder, convert it to .xlsx, and have it update/overwrite an existing .xlsx file. This .xlsx file will serve as the basis for a dashboard, so it's important that the same .xlsx file is getting the new information from each day's .txt file.