Python Forum
Fetch Oracle DB rows & print it in HTML file with table's col headers in table format
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Fetch Oracle DB rows & print it in HTML file with table's col headers in table format
#1
Hi All,

I am new to python. I am using Python 3.6 in Spyder on Windows OS.

Can you please guide on how to achieve the below one's, I need to fetch Oracle DB rows & print it in HTML file with table's column headers in table format :

1. Fetch some 10 or 20 rows & columns using a Oracle select query (example : SELECT * FROM EMP ORDER BY DEPT_ID).

Note : Here, I am able to connect to Oracle DB using cx_Oracle, and execute and print the output in the terminal window

2. Write the fetched rows into a new HTML file.

Note :
a. Tried filewriter.write(SQL), but not able to print the output in the HTML file. Not sure if i need to use any additional libraries to do this step !

b. I am able to do some sample printing like hi, date in HTML file, just to check if i am able to write into HTML file. For formatting purpose, i tried to add some new empty lines into the HTML file, which is not working. print('\n') or print('\\n') or print('\r\n') or filewrite.writer('\n') are not working, also added sys.stdout=filewriter, still not working. Dont know why!?

3. In HTML, the query output should be written, along with table's column headers and this output should be in table format with table borders ( as we see in the GUI Tools like SQL Developer, TOAD, Etc). How to achieve this?

4. Also, interested to know how to give some bold color to only one column alone. Example : Out of 10 columns fetched to display in HTML file, just put RED color for the 4th column alone
Reply
#2
You don't show us your code, so it is guessing. Let me start with the problem to write to the file. Have you read: 7.2. Reading and Writing Files?
So what is the problem?
f = open('aa.html', 'a')
f.write("<table></table>\n")
f.close()
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  drawing a table with the status of tasks in each thread pyfoo 3 355 Mar-01-2024, 09:29 AM
Last Post: nerdyaks
  How to create a table with different sizes of columns in MS word pepe 8 1,413 Dec-08-2023, 07:31 PM
Last Post: Pedroski55
  Trying to get counts/sum/percentages from pandas similar to pivot table cubangt 6 1,323 Oct-06-2023, 04:32 PM
Last Post: cubangt
  dict table kucingkembar 4 662 Sep-30-2023, 03:53 PM
Last Post: deanhystad
  Going through HTML table with selenium emont 3 730 Sep-30-2023, 02:13 AM
Last Post: emont
Thumbs Up Convert word into pdf and copy table to outlook body in a prescribed format email2kmahe 1 704 Sep-22-2023, 02:33 PM
Last Post: carecavoador
  Using pyodbc&pandas to load a Table data to df tester_V 3 746 Sep-09-2023, 08:55 PM
Last Post: tester_V
  Find a string from a column of one table in another table visedwings049 8 1,084 Sep-07-2023, 03:22 PM
Last Post: deanhystad
  Need to replace a string with a file (HTML file) tester_V 1 698 Aug-30-2023, 03:42 AM
Last Post: Larz60+
  How to store columns of a .csv in variables (when the .csv has no headers) ? hobbyist 6 1,146 Aug-18-2023, 02:06 PM
Last Post: deanhystad

Forum Jump:

User Panel Messages

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