openpyxl icon indicating copy to clipboard operation
openpyxl copied to clipboard

Randomly stripping commas from cells in XLSX

Open Phatkone opened this issue 1 year ago • 0 comments

fields that have say up to around 4 commas in them are getting the commas stripped, but fields with more (8 is my reference point) are being retained.

reading the sheet with pandas: svcs = pd.read_excel(file, engine='openpyxl', sheet_name = svc_sheet)

example field: service-http TCP 808080 should be 80, 8080

but, 4172,8443,443,80,4002,8009,8530,22443,32111 retains all the commas.

Phatkone avatar Mar 22 '23 00:03 Phatkone