xlsxwriter considering worksheet.write as tuple ???

[MRAB]

On 2016-09-27 01:34, Mohan Mohta wrote:
> 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
[snip]
>> >>
>> >> 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'?
>> >
>> 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
[snip]
>
> 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.
>
You could post the code at Pastebin.com to avoid filling people's inboxes.