ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[¤À¨É] ¦b win 7 (x64) ¤¤ rows »P columns ªº³Ì¤j­È

[¤À¨É] ¦b win 7 (x64) ¤¤ rows »P columns ªº³Ì¤j­È

Sub Äæ¦C³Ì¤j­È´ú¸Õ()
    Dim rows_count As Long
    Dim column As Long
    rows_count = ActiveSheet.Rows.Count           ' rows_count = 1048576
    column_count = ActiveSheet.Columns.Count  ' column_count = 16384
End Sub

°õ¦æ«á·|¬Ý¨ì rows_count = 1048576 ¤£¬O65536,¦Ócolumn_count ªº­È¬O:16384
¥H¤W­È¬O¦bWin 7 (x64)¤UÅã¥Ü¥X¨Óªº, rows_count ¤@©w­n³]©w¦¨ Long ¤~¤£·|¥X¿ù.
V98

officeª©¥»ªº®t²§¡A«DÃö§@·~¨t²Î¡C
office2007ªºExcel ¬O1048576¦C*16384Äæ
¦b³o¤§«e¬O65536¦C*256Äæ

TOP

ÁÂÁÂ¥Yºl«e½ú,§Ú¥H¬°¬O(X64)ªºÃö«Y,ÁÂÁÂ!!
V98

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD