I have xlsx file that has a date column. The underlying value is a float (has a time component). I want to get the raw value of the cell to convert it to datetime even though the cell is formatted as Date.
I looked through code and could not find a good was to access the cell's raw value. Is there a method similar to rows_with_metadata that would return cell's metadata, including the raw value? Or maybe a custom converter for the column to override format from Date to DateTime?
I have xlsx file that has a date column. The underlying value is a float (has a time component). I want to get the raw value of the cell to convert it to datetime even though the cell is formatted as Date.
I looked through code and could not find a good was to access the cell's raw value. Is there a method similar to rows_with_metadata that would return cell's metadata, including the raw value? Or maybe a custom converter for the column to override format from Date to DateTime?