EXCEL

262,144 Rows and 18,278 Columns

Large spreadsheet

Want more rows, more columns?
Think Excel is too small; Only 65,536 rows and 256 columns?

Try the Spreadsheet control; a Microsoft ActiveX control.

Calculation engine:

A new calculation component for the Spreadsheet provides greater performance, robustness, and compatibility with Microsoft Excel. The new calculation component was built from Excel's source code to provide the highest level of compatibility and dependability. Because the component was built from Excel's sources, it will support all of Excel's built-in formulas, perfect dependencies, array formulas, and discontinuous references.

Named ranges:

An important feature for the Calculation engine that makes it possible for you define a name for a range of cells, a constant, or functions. Then, the name can be used in formulas. Names are interchangeable within Excel.

Support for XML-Spreadsheet:

Both Excel and the Spreadsheet component share a common file format that makes it easy for you to construct, process, share, and extract data from your spreadsheet models. The Spreadsheet component supports Load/Save, Copy/Paste, and Range.Value with XML-Spreadsheet.

Workbooks:

As with classic Excel, you can now work with a collection of sheets in a workbook. This helps you organize your information. By keeping related sheets in the same workbook, it is easier for you to make related changes and edits, to consolidate related sheets, or to do calculations involving data from multiple worksheets. This will also provide better fidelity when publishing from or exporting to Excel.

Excel-compatible object model:

All of the functionality in the Spreadsheet component uses Excel's properties, methods, and events. In some cases, the full functionality of an Excel method is not supported (for example, password protection), but the object model syntax is identical to Excel. This will make it easier to develop Excel Microsoft Visual Basic for Applications (VBA) solutions against the Spreadsheet and ease the process of moving solutions from one version of Microsoft Office to another.

Integrated data-binding in Data Access Pages:

The data-bound worksheets will make it possible for you to drag tables and views from Data Access Page's Field List component and drop them as a Spreadsheet component.

More rows and columns:

The Spreadsheet component now supports 262,144 rows by 18,278 columns (ZZZ).

Custom row and column headers:

Makes it possible for you customize the text that displays in the row and column headers through scripting. Custom text headings make it possible for the Chart component to use the Spreadsheet component as its datasheet.

New look and feel:

The Spreadsheet component now looks the same as the rest of Office 10 by adding lightened row and column headings to help indicate the active selection.

• Right click a toolbar to bring up the Control Toolbox toolbar.
  
• Click on the "More Controls > . ." button
  
• Scroll down to "Microsoft Office Spreadsheet 11.0" (or 10.0 or 9.0).
  
  
  
  
• Now click or draw anywhere on your document. An embedded spreadsheet object will appear.
  
• Right click on the object
  
• select "Microsoft Office Spreadsheet x.0 Object" and, then, Edit from the submenu.

You can use it in Word, Excel, FrontPage, PowerPoint, and Access.

MSDN:
Using Microsoft Access to Create a Spreadsheet Control

You can also use it in Outlook.

OutlookCode.com:
Spreadsheet Control

(Suggested by Doug Smith, www.Abundant-Solutions.com ,
in the Excel-L newsgroup. )


Excel 12 will handle more information:

"Probably the most common question the Excel team gets from our customers is 'when are you going to add more rows/more columns/more rows and more columns'. There are many different scenarios behind these requests. Some customers want to be able to analyze more data than Excel has rows, some customers want to track more daily information than Excel has columns, and other customers want to perform matrix math on large matrices of thousands of elements. There are plenty of other scenarios too. Well, the answer to the question is 'in Excel 12.' Specifically, the Excel 12 grid will be 1,048,576 rows by 16,384 columns. That's 1,500% more rows and 6,300% more columns than in Excel 2003, and for those of you that are curious, columns now end at XFD instead of IV."

If you have a large spreadsheet to send to someone through E-Mail, most likely the file size is going to exceed the server's attachment limit. Why not convert it to something more portable. Try an Excel to PDF converter. The PDF file format converter makes document sizes smaller for transmittal over the Internet. Once received, a PDF to Excel converter can bring it back into an editable form.

See all Topics