How to change cell format to Numeric?

Revit
, ,
1

Hello everybody. Possibly a repeating topic, seems to be an easy one, but i cant find the solution.

I need to change cell format in Excel (ex. from General to Numeric) using Dynamo. Any suggestions of which node can help with that? I was trying to find something in Bumblebee, but i failed. Please help. :roll_eyes:

2

grafik
grafik3031Ă—803 208 KB

#by Deniz Maral

import clr
import sys
import System
from System import Array
from System.Collections.Generic import *
import time
clr.AddReferenceByName('Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c')
from Microsoft.Office.Interop import Excel
System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo("en-US")
from System.Runtime.InteropServices import Marshal
path , c_range = IN		


excel = Excel.ApplicationClass()
wb = excel.Workbooks.Open(path)

excel.Visible = True


wb = excel.Workbooks.Open(path)


ws = wb.ActiveSheet.Range(c_range).Cells.NumberFormat = "0,00"

excel.ActiveWorkbook.Save()
#excel.ActiveWorkbook.Close(True)

#Excel.Application.Quit


OUT= "Success!"
3

Well, This is absolutely right answer to my question!) Sorry, but i didnt mention one little thing.
I must do it when i am writing excel file. The situation is… I have data as string which writes to excel. But, when excel file is created and data is written, it has General format of cell. So look what happens.

image
image345Ă—590 28.8 KB
I have this data.
after i have this excel
image
image1197Ă—304 15.1 KB

So you can see it converts to Date. And if i change it to Numeric, i dont get the original data. So… the question is to change it before file created…
P.S. I am using BB Data node from Bumblebee

4

See if this works for you

image
image1185Ă—916 86.1 KB

5

After creating file get file path and use Passthrough as “wait for” use Node from BumbleeBee and then connect it to my script.

6

That is of course a better solution.

7

Wow, great, Thank you very much! It works!

8

Thank you for your help, anyway! I will might have a use of your script!