xlsxwriter considering worksheet.write as tuple ???

[Mohan Mohta]

On Monday, September 26, 2016 at 6:56:20 PM UTC-5, Nathan Ernst wrote:
> On Mon, Sep 26, 2016 at 6:00 PM, MRAB <python at mrabarnett.plus.com> wrote:
> 
> > On 2016-09-26 23:03, M2 wrote:
> >
> >> Hello
> >> The program is designed to collect different statistics from servers
> >> across the network and populate in excel sheet.
> >> Library : xlsxwriter.0.9.3
> >>
> >> Below is the Snip of code being used
> >> #! /usr/bin/python
> >>
> >> import xlsxwriter
> >> import os;
> >> import subprocess;
> >> import sys;
> >> import os.path;
> >>
> >>
> >> workbook=xlsxwriter.Workbook('Turnover_sheet.xlsx');
> >>
> >> tools_sheet=workbook.add_worksheet('Citi Tools Verification');
> >>
> >> hw_sheet=workbook.add_worksheet('Hardware Verification');
> >>
> >> os_sheet=workbook.add_worksheet('OS Verification');
> >>
> >> build_spec_sheet=workbook.add_worksheet('Build Specs Verification');
> >>
> >> info_sheet=workbook.add_worksheet('Server Handover Info');
> >>
> >> stan_sheet=workbook.add_worksheet('Standards');
> >>
> >> sup_sheet=workbook.add_worksheet('Support Information');
> >>
> >> tools_sheet.write('A3', 'Device Name', table_head);
> >>
> >> tools_sheet.write('B3', 'Machine Category', table_head);
> >>
> >> tools_sheet.write('C3', 'OS Platform', table_head);
> >>
> >>
> >> hw_sheet.merge_range('A1:N1', 'Hardware Information', head);
> >>
> >> hw_sheet.merge_range('A2:A3', 'Device Name', table_head);
> >>
> >> hw_sheet.merge_range('B2:B3', 'CPU / vCPU Count', table_head);
> >>
> >>
> >> os_sheet.merge_range('A2:A3', 'Server Name', table_head);
> >>
> >> os_sheet.merge_range('B2:B3', 'Kdump Config', table_head);
> >> os_sheet.merge_range('C2:C3', 'Grub Config', table_head);
> >>
> >>
> >> info_sheet.write('A1', 'Server Name', table_head);
> >>
> >> info_sheet.write('B1', 'Serial Number', table_head);
> >>
> >> info_sheet.write('C1', 'Backup Type', table_head);
> >>
> >>
> >> stan_sheet.write('A1', 'Item', table_head);
> >>
> >> stan_sheet.write('B1', 'Standard', table_head);
> >>
> >> stan_sheet.write('C1', 'Comments', table_head);
> >>
> >>
> >> def data_collection(fqdn,counter):
> >>         counter=int(counter);
> >>         red_counter=(int(counter))-2;
> >>         s_count='A'+str(counter);
> >>         s_r_count='A'+str(red_counter);
> >>         tools_sheet.write(s_count,fqdn,cell_format);
> >>         hw_sheet.write(s_count,fqdn,cell_format);
> >>         os_sheet.write(s_count,fqdn,cell_format);
> >>         info_sheet.write(s_r_count,fqdn,cell_format);
> >>         s_count='D'+str(red_counter);
> >>         sup_sheet.write(s_count,fqdn,cell_format);
> >>
> >> I get the following error
> >>     sup_sheet.write(s_count,fqdn,cell_format);
> >> TypeError: 'tuple' object is not callable
> >>
> >> What I do not understand is why is python thinking  sup_sheet.write as
> >> tuple.
> >> I tired to debug the program and added the following line
> >> print "\ts_count is ", type(s_count)," and value",s_count,"\n\tfqdn is ",
> >> type(fqdn), " and value is ",fqdn,"\n\tcell_format is ", type(cell_format),
> >> " and value is ",cell_format,"\n\t sup_sheet is ",type(sup_sheet)," and
> >> value is ",sup_sheet,"\n\n\n";
> >>
> >> just before
> >> sup_sheet.write(s_count,fqdn,cell_format);
> >>
> >> And I got the following output:
> >>          s_count is  <type 'str'>  and value D2
> >>         fqdn is  <type 'str'>  and value is  Sample1.xyz.com
> >>         cell_format is  <class 'xlsxwriter.format.Format'>  and value is
> >> <xlsxwriter.format.Format object at 0x1eb3150>
> >>          sup_sheet is  <class 'xlsxwriter.worksheet.Worksheet'>  and
> >> value is  <xlsxwriter.worksheet.Worksheet object at 0x1eac610>
> >>
> >>
> >>
> >>         s_count is  <type 'str'>  and value D3
> >>         fqdn is  <type 'str'>  and value is  sample2.xyz.com
> >>         cell_format is  <class 'xlsxwriter.format.Format'>  and value is
> >> <xlsxwriter.format.Format object at 0x1eb3150>
> >>          sup_sheet is  <class 'xlsxwriter.worksheet.Worksheet'>  and
> >> value is  <xlsxwriter.worksheet.Worksheet object at 0x1eac610>
> >>
> >>
> >>
> >> Traceback (most recent call last):
> >>   File "./turnover_sheet.py", line 398, in <module>
> >>     data_population(str(sys.argv[1]));
> >>   File "./turnover_sheet.py", line 380, in data_population
> >>     data_collection(fqdn,count);
> >>   File "./turnover_sheet.py", line 219, in data_collection
> >>     sup_sheet.write(s_count,fqdn,cell_format);
> >> TypeError: 'tuple' object is not callable
> >>
> >> I also saw the sheet populated with the first server and when it went to
> >> the second server and while populating it considered
> >> sup_sheet.write as a tuple which makes no sense because the rest of the
> >> writes are working fine.
> >>
> >> I have no clue why is it doing it ?
> >> Thoughts ?
> >>
> >> I can't see a problem in the part of the code that you've posted.
> >
> > Are there any other lines that use 'sup_sheet'?
> >
> > --
> > https://mail.python.org/mailman/listinfo/python-list
> >
> 
> There's nothing wrong with the snippet as shown - the problem must be
> elsewhere.  I took the snippet as in the original email and made some
> slight changes to define cell_format, head and table_head & close the
> workbook:
> 
> #!/usr/bin/env python
> import xlsxwriter
> import os;
> import subprocess;
> import sys;
> import os.path;
> 
> workbook = xlsxwriter.Workbook('Turnover_sheet.xlsx');
> cell_format = workbook.add_format({})
> head = table_head = workbook.add_format({'bold': True})
> 
> # snipped the rest
> 
> data_collection("sample1.xyz.com", 2)
> data_collection("sample2.xyz.com", 3)
> 
> workbook.close()
> 
> This runs cleanly for me with xlsxwriter 0.9.3 on Python 2.7.6.
> 
> I understand this is a snippet, but it feels like you may be reassigning
> sup_sheet. Or, possibly assigning to "sup_sheet.write" somewhere. I'd
> search with the regex "sup_sheet.write\s*=" to see if you get any hits.
> 
> Hope this helps.
> 
> Regards

Thanks for looking into this.

Well I have been using the following which works fine 
	sup_sheet.write('A1', 'Project Name', table_head);
	sup_sheet.write('B1', 'SLTN # ', table_head);
	sup_sheet.write('C1', 'Env Label', table_head);
	sup_sheet.write('D1', 'Hostname', table_head);
	sup_sheet.write('E1', 'ServerType(Physical/Physical Cluster/VM)', table_head);
	sup_sheet.write('F1', 'Server Type', table_head);
	sup_sheet.write('G1', 'App Support SNOW', table_head);
	sup_sheet.write('H1', 'App Primary Contact', table_head);
	sup_sheet.write('I1', 'Production Support', table_head);
	sup_sheet.write('J1', 'Comments', table_head);

Also if you see the output; the program does what it is supposed to do during the first run
 s_count is  <type 'str'>  and value D2 
        fqdn is  <type 'str'>  and value is  Sample1.xyz.com 
        cell_format is  <class 'xlsxwriter.format.Format'>  and value is  <xlsxwriter.format.Format object at 0x1eb3150> 
         sup_sheet is  <class 'xlsxwriter.worksheet.Worksheet'>  and value is  <xlsxwriter.worksheet.Worksheet object at 0x1eac610> 


But when it picks the second server from the list and starts doing what it needs to do then for whatever reason it thinks that this is a tuple 
sup_sheet.write(s_count,fqdn,cell_format);


Let me know if you need I can load the entire program ( if it helps )
It is just that it is a still in progress and is a 400+ lines of code.