Programming Excel with VBA and .NET
Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. Wit...
| Autor principal: | |
|---|---|
| Autor Corporativo: | |
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing :
O'Reilly
2006.
|
| Edición: | First edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627171906719 |
Tabla de Contenidos:
- Becoming an Excel programmer
- Knowing the basics
- Tasks in visual basic
- Using Excel objects
- Creating your own objects
- Writing code for use by others
- Controlling Excel
- Opening, saving, and sharing workbooks
- Working with worksheets and ranges
- Linking and embedding
- Printing and publishing
- Loading and manipulating data
- Analyzing data with pivot tables
- Sharing data using lists
- Working with XML
- Charting
- Formatting charts
- Drawing graphics
- Adding menus and toolbars
- Building dialog boxes
- Sending and receiving workbooks
- Building add-ins
- Integrating DLLs and COM
- Getting data from the Web
- Programming Excel with .NET
- Exploring security in depth.
