arras-energy / gridlabd

Arras Energy simulator
https://www.arras.energy/
BSD 3-Clause "New" or "Revised" License
5 stars 5 forks source link

XLSX artifacts not handled corrected within the converter #169

Closed aivanova5 closed 6 months ago

aivanova5 commented 6 months ago

Problem description

Some XLSX files replace spaces with _x0020_. Need to make sure the converter handles this correctly.

warn ("Workbook contains no default style, apply openpyl's default")
Index (['ProjectID',
'DesignLayer',
'Structure X0020 ID'
'Project_X0020_ID_X0020_1',
"BW_x0020_Delta_x0020_Process:_X0020_Record_x0020_Mode',
"Calc_x0020_Version'
'Calc_x0020_Version_x0020_1', , 'GLC_x0020 _Unit'
'GLC_X0020_Value', 'AGL_X0020_Unit', 'AGL_x0020_Value', 'Environment'
'Temperature_x0020_Unit', Temperature x0020_Value',
'Stress_x0020_Ratio',
'Species',
'Class',
'Height_x0020_Unit',
'Height_x0020_Value', , 'Owner',
"AS-IS_X0020_AGL'
'Owner_x0020_Industry', 'AS-IS_X0020_Species', 'AS-IS_x0020_GLC',
'AS-IS_X0020_Owner', 'AS-IS_X0020_Length', 'AS-IS_X0020_Class',
'AS-IS_x0020_Allowable_X0020_Stress_X0020_Adjustment'
"AS-IS_x0020_Effective_x0020_Stress_×0020_Adjustment',
"AS-IS_x0020_GPS_X0020_Point',
'SCE_x0020_QC_X0020_Length',
'SCE_x0020_QC_x0020_Species',
'SCE_X0020_QC_X0020_Class'
'SCE_X0020_QC_X0020_AGL', 'SCE_x0020_QC_X0020_GLC',
'SCE_X0020_QC_X0020_Allowable_X0020_Stress_X0020_Adjustment'
'SCE_x0020_QC_x0020_Effective_x0020_Stress_X0020_Adjustment'
'SCE_X0020_QC_X0020_GPS_X0020_Point',
'Rework_x0020_Species'
'Rework_x0020_Length',
'Rework_x0020_GLC',
"Rework_X0020_Class',
'Rework_X0020_AGL',
'Rework_×0020_Allowable_X0020_Stress_X0020_Adjustment',
'Rework_X0020_Effective_X0020_Stress_X0020_Adjustment',
'Rework_x0020_GPS_X0020_Point',
'SCE_X0020_QC_X0020_Owner',
'Rework_x0020_Owner', 'COUNT', , 'Ext_x0020_Last_x0020_RunTIme',
'Ext_x0020_Last_X0020_Run_X0020_Date',
'Time_x0020_Modified'],
'Date_x0020_Modified',
dtype='object')