Python Forum
Convert Excel file into csv with Pipe symbol..
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Convert Excel file into csv with Pipe symbol..
#5
This is a simple task in python
  • load the excel 'recon' sheet using pandas see: pandas.read_excel
    look at examples at bottom of page.
  • write pandas frame: see DataFrame.to_csv
    look at attribute " sep='|' " (on same document page) to set your separator.

there are only 3 (4 if you make cell selection a separate line) lines of code necessary

  1. import pandas
  2. load the excel page
  3. write selected cells to the csv page

That's it
Reply


Messages In This Thread
RE: Convert Excel file into csv with Pipe symbol.. - by Larz60+ - Oct-18-2022, 02:59 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Media Pipe Python Interfacing with MATLAB cmcreecc 1 153 May-30-2024, 07:23 AM
Last Post: TrentErnser
  Python openyxl not updating Excel file MrBean12 1 449 Mar-03-2024, 12:16 AM
Last Post: MrBean12
Question [SOLVED] Correct way to convert file from cp-1252 to utf-8? Winfried 8 1,365 Feb-29-2024, 12:30 AM
Last Post: Winfried
  Copy Paste excel files based on the first letters of the file name Viento 2 558 Feb-07-2024, 12:24 PM
Last Post: Viento
  Decryption not working if key has same symbol like text Paragoon2 0 389 Nov-11-2023, 09:32 PM
Last Post: Paragoon2
  python Read each xlsx file and write it into csv with pipe delimiter mg24 4 1,737 Nov-09-2023, 10:56 AM
Last Post: mg24
  Search Excel File with a list of values huzzug 4 1,375 Nov-03-2023, 05:35 PM
Last Post: huzzug
  Updating sharepoint excel file odd results cubangt 1 972 Nov-03-2023, 05:13 PM
Last Post: noisefloor
  Convert File to Data URL michaelnicol 3 1,355 Jul-08-2023, 11:35 AM
Last Post: DeaD_EyE
  Python Script to convert Json to CSV file chvsnarayana 8 2,720 Apr-26-2023, 10:31 PM
Last Post: DeaD_EyE

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020