Format: application/x-python-code
1 o
2
3 ��h� � @ s@ d dl Z d dlZz d dlmZ e�� ZW n ey dZY nw er%dZndZdZdZ deee f Z
4 e� e
5 �Z e �Q e �
6 � �=Zze�d� W n Y e�d � d
7 Zd d d
8 de �ddd�fZe�ee� e�edddde �ddd�g� W d � n1 s~w Y W d � n1 s�w Y e �� ededf � dS )� NFzMicrosoft.ACE.OLEDB.12.0zMicrosoft.Jet.OLEDB.4.0zxx.xlsz/Extended Properties="Excel 8.0;Readonly=False;"z Provider=%s;Data Source=%s;%szdrop table SheetOnez^create table SheetOne (Name varchar, Rank varchar, SrvcNum integer, Weight float, Birth date)zMINSERT INTO SheetOne (name, rank , srvcnum, weight, birth) values (?,?,?,?,?)z Mike MurphyZSSGi�[g������d@i� � � z
9 John JonesZPvti�h�:g �a@i� � � z#Created spreadsheet=%s worksheet=%sZSheetOne)�datetimeZadodbapiZadodbapi.is64bitZis64bit�PythonZis64� ImportErrorZdriver�filename�extendedZconstr�connect�conn�cursorZcrsr�execute�sql�date�data�close�print� r r �Qc:\Users\shubh\Videos\agent\nova\Lib\site-packages\adodbapi/examples/xls_write.py�<module> sF �
10
11 � � �� �