It depends on data type or number of characters..?If i convert a csv file into xls file,file size of .xls will be 3X times of csv file.So it depends on what format we are saving as well.?Any idea on how much bytes needed to hold a character in xls(csv file ---1 character---1 bytes)

CodePudding user response：

It depends on number of rows,columns and sheets we are trying to add.Even an empty rows occupies a some bytes and char occupies 1 bytes(space,spl characters as well).I have checked manually by iterating xml sheet by adding rows,columns and sheets. Workbook-314bytes ,Rows - 35 bytes ,columns- 43 bytes ,worksheet-73 bytes & char- 1bytes.