long description This sample demonstrates data analysis tasks executed using toolbar buttons and menus in Microsoft Office Excel 2007. The data is stored in XML files. In addition, the sample is completely localizable; it demonstrates how to take advantage of System.Resources..::.ResourceManager and managed resource (RESX) files.
The code was written to be globalized using culture-switching techniques that were necessary in earlier versions of Visual Studio Tools for Office. Those techniques are no longer necessary because of a change in how Visual Studio Tools for Office works with Excel. For more information, see Globalization and Localization of Office Solutions, Formatting Data in Excel with Various Regional Settings, and How to: Make String Literals Region-safe in Excel Using Reflection. Note: This sample does not run if you have an English language version of Office running on Windows with regional settings other than English (United States). The sample is a simple inventory management tool for a fictitious ice cream store. The workbook has systems for tracking sales, inventory in storage, and the products sold. Each of these systems stores data in XML files. The store has the following constraints on inventory: Storage capacity is limited to 300 units of ice cream. Ice cream orders are delivered once per week, in the morning.
Orders must be placed a minimum of two days before scheduled delivery date. The schedule is to place the order on Tuesday, and receive delivery on Thursday. If additional stock is needed outside of the normal delivery schedule, there is an additional charge of 25 to have the order delivered. Security Note: This sample code is intended to illustrate a concept, and it shows only the code that is relevant to that concept. It may not meet the security requirements for a specific environment, and it should not be used exactly as shown.