excel-2010
Excel Sparklines not exported to PDF when using COM Automation
I am having a problem programmatically exporting Excel sheets that contain sparklines to PDF format. When I manually export the Excel sheet to PDF format using Excel 2010\'s native PDF Exporting faci[详细]
2023-01-25 19:02 分类:问答SQL & Excel 2010
Good morning, Does anyone know if there is an easy way I can use a SQL query in Excel to select specific data from an Excel spreadsheet without having to use VBA, Access, an SQL database or complicat[详细]
2023-01-22 17:47 分类:问答Any way to hide Slicer Values in Excel 2010
I know that Excel 2010 Slicers will visually indicate when there is no data associated with a particular slicer selection. For example, they are faded in color for 2010 if you have no values in 2010.[详细]
2023-01-21 21:39 分类:问答How do I check if an Excel cell's Date is within one week?
I\'m using VBA in Excel 2010 to make a simple birthday reminder program. I have a column of dates (Column D). How do I check if a cell is within one week of today?[详细]
2023-01-12 08:19 分类:问答Excel sparklines printing issue
In an Excel 2010 document with more than one page of r开发者_开发知识库ecords, where each row includes a sparkline, the sparklines do not print or appear in print preview unless one first scrolls thro[详细]
2023-01-10 02:06 分类:问答A way to display an excel 2010 document in an asp.net web application
I am wanting to display an Excel 2010 document in an asp.net web application. This document uses the new slicer functionality which I want to be available to the user.[详细]
2023-01-07 07:49 分类:问答Loop this Excel Macro?
I have this code below, and basically I want to able to make it do a whole range of cells from R16 to R200 and Range(\"G16\").Select to G200.[详细]
2023-01-05 15:34 分类:问答Excel: the Incredible Shrinking and Expanding Controls [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.[详细]
2022-12-08 01:32 分类:问答Is there a function within MS Excel which helps to match a particular variable with a subset of a dataset and performs calculations on it?
I am currently doing a project and have been searching online for a solution but have not found one yet.[详细]
2022-12-07 17:57 分类:问答