Csvkit : use "in2csv" in python code

Question

I'd like to use in2csv to convert excel files into csv in my python code, but without running it as a separate process using exec. Instead, I'd like to directly import the function and use it, like in2csv("input.xls", "output.csv"), or still better, get directly the structure of the file in python without using the csv reader out the output file.

Is it possible?

Thank you!

Rahul Kumar · Accepted Answer · 2019-10-03 10:25:06Z

2

I also had the same issue. I looked into the source code of in2csv and found it internally uses agate and agateexcel. I directly used agate and implemented the following way

For xls file

import agate
import agateexcel

table = agate.Table.from_xls('input.xls', sheet='sheet')

table.to_csv('output.csv')

For xlsx file

import agate
import agateexcel

table = agate.Table.from_xlsx('input.xlsx', sheet='sheet')

table.to_csv('output.csv')

https://github.com/wireservice/csvkit/blob/master/csvkit/utilities/in2csv.py

answered Oct 3, 2019 at 10:25

Rahul Kumar

2,4055 gold badges27 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Manoj Kumar Over a year ago

How to specify delimiter?

Rahul Kumar Over a year ago

In csv file while saving ?

Manoj Kumar Over a year ago

yes. sep and delimiter keyword are not accepted.

Collectives™ on Stack Overflow

Csvkit : use "in2csv" in python code

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related