Translate Excel table data to normal text data

2 views
Skip to first unread message

sp kishore

unread,
Feb 2, 2018, 8:27:02 AM2/2/18
to santosh kumar, lamp_t...@googlegroups.com
Hi team
 
Can anyone help me in export the Excel table data into normal text data.

Thanks
Spkishore.

chiru toleti

unread,
Feb 2, 2018, 8:46:34 AM2/2/18
to sp kishore, santosh kumar, lamp_t...@googlegroups.com
Hi Kishore,

Just change the format of the file.

Thanks,
Chiru

Sent from my iPhone
--
You received this message because you are subscribed to the Google Groups "Lamp_tutorial" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lamp_tutoria...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

sp kishore

unread,
Feb 2, 2018, 9:06:41 AM2/2/18
to chiru toleti, lamp_t...@googlegroups.com, santosh kumar
Hi team,
 
Please check this snapshort

That table data should be convert  to data format.(starting with incident bottom table)

Need to import that data as a text format.

Thanks
Spkishore

On Feb 2, 2018 7:16 PM, "chiru toleti" <chiru...@gmail.com> wrote:
Hi Kishore,

Just change the format of the file.

Thanks,
Chiru

Sent from my iPhone

On 02-Feb-2018, at 6:56 PM, sp kishore <kishore...@gmail.com> wrote:

Hi team
 
Can anyone help me in export the Excel table data into normal text data.

Thanks
Spkishore.

--
You received this message because you are subscribed to the Google Groups "Lamp_tutorial" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lamp_tutorial+unsubscribe@googlegroups.com.
IMG_20180202_193000__01.jpg

udhay prakash pethakamsetty

unread,
Feb 2, 2018, 10:31:43 AM2/2/18
to sp kishore, chiru toleti, Lamp_tutorial, santosh kumar
if I understood correctly, you are expecting the content shown to be stored in a text file. 

Is it an HTML file? 
If it is, then is there any pattern in the URL for each record. 

If both are present, then you can use requests module(http://docs.python-requests.org/en/master/) to download the file. 



regards

UDHAY PRAKASH

udhay prakash pethakamsetty

unread,
Feb 2, 2018, 10:44:08 AM2/2/18
to sp kishore, chiru toleti, Lamp_tutorial, santosh kumar
Hi 

Find the below python script. It is working decently. 
It took the .xlsx file and converted it to .csv file 


regards

UDHAY PRAKASH

On Fri, Feb 2, 2018 at 9:05 PM, sp kishore <kishore...@gmail.com> wrote:
Hi uday,

Actually information what I need is present in Excel sheet ..
In Excel sheet that too in a table

I need to extract that data.

Thanks
So kishore

xlsx_to_csv_converter.pyw
SampleData.csv
SampleData.xlsx

shaik sameera

unread,
Sep 4, 2019, 12:30:51 AM9/4/19
to sp kishore, tuxfu...@gmail.com, lamp_t...@googlegroups.com
Hi all,

I am beginner in python scripting ,but I have been given to write difficult script which am not able to think of options ...

I should write either one.,please help me with the steps ...

Question :write a script to read a list of Linux servers as input.output should display the products
(Apache,tomcat,jboss,weblogic) Installed in each server.  

Or 

Question: find all Java installations on servets ( eg:jdk1.8.0_201-64 and jdk1.8.0_212-64) and do the following
a) display the absolute paths for each Java installation?
b)
Display for each Java ,if it's JDK or JRE

c)display the lastest minor version found on the server.

Regards,
Sameera

--
You received this message because you are subscribed to the Google Groups "Lamp_tutorial" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lamp_tutoria...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages