On 2015-05-06 20:22, Tim Chase wrote:
> As ChrisA posted earlier, you have to use Excel's Import
> functionality (there are several ways to get this wizard, but not
> all ways of opening a .csv trigger the wizard), then specify those
> particular columns as "Text" rather than "General"
Sorry, it w
On 2015-05-06, Denis McMahon wrote:
> You need to format your CSV date into a date format that Excel
> understands when it imports it.
>
> First thing to try would be to export some dates from excel as CSV and
> see what format excel puts them in.
Beware of assuming that Excel can import its ow
On 2015-05-06 23:31, Denis McMahon wrote:
> On Tue, 05 May 2015 22:32:28 -0700, Kashif Rana wrote:
> > thanks for the feedback. I think its problem with excel itself,
> > showing wrong value. Because when I opened the csv file in text
> > editor, I can see correct value but opening in excel showing
On Tue, 05 May 2015 22:32:28 -0700, Kashif Rana wrote:
> thanks for the feedback. I think its problem with excel itself, showing
> wrong value. Because when I opened the csv file in text editor, I can
> see correct value but opening in excel showing wrong value. What I can
> do to see correct in e
On 2015-05-06 12:27, Ian Kelly wrote:
> On Wed, May 6, 2015 at 12:22 PM, Tim Chase
> wrote:
> > On 2015-05-06 19:08, MRAB wrote:
> >> You could tell it to quote any value that's not a number:
> >>
> >> w = csv.DictWriter(f, pol_keys,
> >> quoting=csv.QUOTE_NONNUMERIC)
> >>
> >> It looks like
On Wed, May 6, 2015 at 12:22 PM, Tim Chase
wrote:
> On 2015-05-06 19:08, MRAB wrote:
>> You could tell it to quote any value that's not a number:
>>
>> w = csv.DictWriter(f, pol_keys,
>> quoting=csv.QUOTE_NONNUMERIC)
>>
>> It looks like all of the values you have are strings, so they'll
>> a
On 2015-05-06 19:08, MRAB wrote:
> You could tell it to quote any value that's not a number:
>
> w = csv.DictWriter(f, pol_keys,
> quoting=csv.QUOTE_NONNUMERIC)
>
> It looks like all of the values you have are strings, so they'll
> all be quoted.
>
> I would hope that Excel will then treat
t would be
stupid if it didn't! :-)
On Tuesday, May 5, 2015 at 9:09:40 PM UTC+4, Kashif Rana wrote:
Hello Experts
When I am writing list of dictionaries to CSV file, the key 'schedule' has
value 'Mar 2012' becomes Mar-12. I really do not have clue why thats happening.
B
Op Wednesday 6 May 2015 07:32 CEST schreef Kashif Rana:
> thanks for the feedback. I think its problem with excel itself,
> showing wrong value. Because when I opened the csv file in text
> editor, I can see correct value but opening in excel showing wrong
> value. What I can do to see correct in
On Wed, May 6, 2015 at 3:32 PM, Kashif Rana wrote:
> thanks for the feedback. I think its problem with excel itself, showing wrong
> value. Because when I opened the csv file in text editor, I can see correct
> value but opening in excel showing wrong value. What I can do to see correct
> in ex
at 9:09:40 PM UTC+4, Kashif Rana wrote:
> Hello Experts
>
> When I am writing list of dictionaries to CSV file, the key 'schedule' has
> value 'Mar 2012' becomes Mar-12. I really do not have clue why thats
> happening. Below is the code.
>
> dic
On 2015-05-05 10:09, Kashif Rana wrote:
> When I am writing list of dictionaries to CSV file, the key
> 'schedule' has value 'Mar 2012' becomes Mar-12.
How are you making this determination? Are you looking at the raw
CSV output, or are you looking at the CSV file load
On 2015-05-05 14:25, Skip Montanaro wrote:
> More likely, viewing the CSV file in Excel, Gnumeric, or some other
> spreadsheet which interprets some inputs as dates and formats them
> according to its default rules. Skip
This is depressingly common, and I've even received CSV and plain text
data
Op Tuesday 5 May 2015 19:09 CEST schreef Kashif Rana:
> When I am writing list of dictionaries to CSV file, the key
> 'schedule' has value 'Mar 2012' becomes Mar-12. I really do not have
> clue why thats happening. Below is the code.
>
> dic_1 = {'action&#
On Tue, May 5, 2015 at 1:11 PM, MRAB wrote:
> I'm assuming that you're reading the CSV file in a text editor, not
> some other application that might be trying to be "clever" by
> "interpreting" what it thinks looks a date as a date and then
> displaying it differently...
More likely, viewing the
On 2015-05-05 18:09, Kashif Rana wrote:
Hello Experts
When I am writing list of dictionaries to CSV file, the key 'schedule' has
value 'Mar 2012' becomes Mar-12. I really do not have clue why thats happening.
Below is the code.
dic_1 = {'action': 'permit&#x
Hello Experts
When I am writing list of dictionaries to CSV file, the key 'schedule' has
value 'Mar 2012' becomes Mar-12. I really do not have clue why thats happening.
Below is the code.
dic_1 = {'action': 'permit',
'dst-address': '
17 matches
Mail list logo
