Python icon indicating copy to clipboard operation
Python copied to clipboard

Convert to excel or csv

Open Jatinsharma250 opened this issue 3 years ago • 5 comments

import all required library

Import xlrd Import csv Import pandas csv

open workbook by sheet index

optional_sheet_by_index()

Sheet=xlrd.open_workbook("Test.xlsx").sheet_by_index(0)

writen object is created

Col= csv.writen(open("Tcsv",'w',newline=" " ))

writing the data into csv file for row in range(sheet.nrows):

row by row write

operation is perform

Col.writerow (sheet.row_valued(row))

read csv file and convert

into a dataframe object

df=pd.Data frame(pd.read_csv("Tcsv)))

show the data frame df

Jatinsharma250 avatar Jan 27 '22 19:01 Jatinsharma250

@Jatinsharma250, I would like to contribute to this issue. Could you please assign it to me.

Vandinimodi1595 avatar Jan 28 '22 01:01 Vandinimodi1595

Hi, if I am allowed to, I would like to contribute. I would like some guidance as I am a beginner.

dhrubo28 avatar Jan 30 '22 01:01 dhrubo28

@Jatinsharma250 hi, please assign me the issue, happy to help 😊

Doctorshe avatar Feb 12 '22 08:02 Doctorshe

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] avatar Apr 25 '22 13:04 stale[bot]

Hey There Actually, I have written this module some while ago for one of my projects, if I might I would really happy to contribute to this section.

Bakhtaki avatar Jul 11 '22 11:07 Bakhtaki