[PA] 업무자동화/[XL]Excel & VBA
XL 1048576 XFD
Weneedu
2023. 7. 2. 02:29
2023 0701
REF
[1] https://answers.microsoft.com/en-us/msoffice/forum/all/why-does-an-excel-spreadsheet-end-at-1048576-and/0007c3c4-0785-45a4-ad63-78b930773a5e ,
[2]
https://support.socrata.com/hc/en-us/articles/115005306167-Limitations-of-Excel-and-CSV-Downloads#:~:text=Cell%20Character%20Limits&text=Both%20.,and%2016%2C384%20columns%20per%20sheet. ,
엑셀의 맨 마지막 셀 주소
1) 셀 개수 = 2^20 × 2^14..백만 곱하기 만육천
2) 하나의 셀..크기는 3.2만 character