Hi,
Im struggling with the data.
Ive tried all options to have the data working in the status bar where you can see, when select mutiple cells, the average sum max etc is shown.
The file is updated every minute.
When i double click a cell, its working, but as soon as the file is updated, its not working again....
I have made a script to try.
Its taking ages to have the output and in all cells theres a little black triangle shown.
When i click that triangle, i can convert to numeric.
But i want it to automatic have all the data in numeric.
Im struggling with the data.
Ive tried all options to have the data working in the status bar where you can see, when select mutiple cells, the average sum max etc is shown.
The file is updated every minute.
When i double click a cell, its working, but as soon as the file is updated, its not working again....
I have made a script to try.
Its taking ages to have the output and in all cells theres a little black triangle shown.
When i click that triangle, i can convert to numeric.
But i want it to automatic have all the data in numeric.
import pandas as pd
import openpyxl
df = pd.read_table("C:\\Campbellsci\\LoggerNet\\CR1000_Table1.dat", delimiter=',', low_memory=False)
a=df.to_excel("C:\\Users\\Makada\\Desktop\\Map1.xlsx")
df1=pd.to_numeric(a,errors='coerce')