All Forums  Origin Forum for Programming  Forum for Python  Date format using Set column values

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by belebele[/i] [br]Hello, I use a data connector to import excel files containing several sheets. I want to copy two specific cells (B2 and C2 in the example below) of one of the sheets into a new worksheet where I gather all my results. However, when I copy those specific cells into the new worksheet, there is no value displayed "--". The problem comes obviously from the format of the imported cells. Therefore, I would like to change the format of the imported cells automatically. In order to so, I have implemented a python code in "Set columns values". When my data is a number, it works well as you can see below. In the screenshot, I have simplified the structure of the sheet to make the issue clearer: (t refers to col(D) and tim to col(B)). The cell D1 contains now the value of B2 in the right format. [img]https://my.originlab.com/ftp/forum_and_kbase/Images/str%20to%20float.png[/img] I am now trying to write another function to do the same with the date format in col(C) but I don't understand well what should I use in this case instead of "float". I have tried the following code but it doesn't work. t refers to col(E) and tim to col(C). [img]https://my.originlab.com/ftp/forum_and_kbase/Images/date%20to%20date.png[/img] Do you have any suggestion to make this work? I don't want to change the format of the cell directly in the excel file as I have a huge amounts of excel files to treat. Also, I am using a data connector to import those excel files quickly (they all have the same structure). Thanks a lot for your help, Greg [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.