Issue in writing sql data into csv for decimal value to scientific notation

[mg24]

Hi Larz60,

Thanks for your help,

below code is working for first column.

no = float(row[0])
if no == 0.0:
    writer.writerow(0.0)

how to dynamically check it for all columns
float(row[0]) ------------row[0] is hard coded value here


Thanks
mg

Larz60+ write Nov-28-2022, 07:32 PM:
Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.
Fixed for you this time. Please use BBCode tags on future posts.