More information about worksheets is available in the What is a Worksheet? section.Īctive Worksheet: The workbook exposes a property that indicates the active worksheet. It also allows you to move worksheets within the workbook or simply iterate through them. The workbook has several important characteristics:Ĭollection of Worksheets: Each workbook maintains a collection of worksheets that allows you to add and delete worksheets. Further information is available in the Create, Open and Save Workbooks article and the Formats and Conversion section. To save a document you can export its contents into a csv, txt, xlsx, xls file or a DataTable. You can create a workbook from scratch or import an existing document. For example, an annual budget workbook may comprise four worksheets that break down the budget in quarters. Typically, a workbook has a single theme and contains worksheets with related data. The workbook is designed to hold together multiple worksheets in order to allow efficient organization and consolidation of data. Each workbook contains, at least, one worksheet and often holds several sheets with related information. The workbook can also be viewed as a collection of worksheets, where a worksheet is in turn defined as a collection of cells organized in rows and columns. It is the primary document that you use to retrieve, manipulate and store data. The workbook lays in the core of the SpreadProcessing' document model. This article will help you get familiar with the representation of an Excel workbook in the model of SpreadProcessing. Download free 30-day trial What is a Workbook?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |