表达一个代表Slicers对象的变量。 参数 名称必需/可选数据类型说明 SlicerDestination必需Variant指定工作表名称的String,或表示工作表的Worksheet对象,将放置生成的切片器。 目标工作表必须位于包含表达式指定的Slicers对象的工作簿中。 Level可选Variant如果是 OLAP 数据源,则为创建切片器所基于的级别的序号或多维表达式 (...
// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/38-pivottable/pivottable-slicer.yamlawaitExcel.run(async(context) => {constsheet = context.workbook.worksheets.getItem("Pivot");constslicer = sheet.slicers.add("Farm Sales",/* The slic...
Slicers.Add 方法 (Excel) Microsoft Learn Challenge Nov 23, 2024 – Jan 10, 2025 立即報名 關閉警示 Learn 發現卡 產品文件 開發語言 主題 登入 本文已針對您的市場由英文翻譯而成。 您對使用的語言品質滿意度如何? ShapeNode 物件 ShapeNodes 物件...
程序集: Microsoft.Office.Interop.Excel.dll 创建新的切片器并返回 Slicer 对象。 C# 复制 public Microsoft.Office.Interop.Excel.Slicer Add (object SlicerDestination, object Level, object Name, object Caption, object Top, object Left, object Width, object Height); 参数 SlicerDestination Object 一个...
Excel.SlicerSortType enum We use optional cookies to improve your experience on our websites, such as through social media connections, and to display personalized advertising based on your online activity. If you reject optional cookies, only cookies necessary to provide you the services will be ...
Technique #2: Use the right-click to add a slicer with Excel Online? This was the only way to add a slicer in Excel Online before 2023. Go to thePivot Table pane Put your mouse over a field Click on the arrow on the right
Assembly: Microsoft.Office.Interop.Excel.dll This object, member, or enumeration is deprecated and is not intended to be used in your code. C# 複製 public Microsoft.Office.Interop.Excel.SlicerCache Add (object Source, object SourceField, object Name); Parameters Source Object SourceFie...
Sign in Office Add-ins Guides Office applications Resources Free account Version Excel JavaScript API Preview Search Office Add-ins Documentation About Office Add-ins Get started Development lifecycle Excel OneNote Outlook PowerPoint Project Visio Word Transition from VSTO and COM Resources API...
getItem(key:string): Excel.SlicerItem; Parameters key string The key or name of the slicer item. Returns Excel.SlicerItem Remarks [API set: ExcelApi 1.10] getItemAt(index) Gets a slicer item based on its position in the collection.
[API set: ExcelApi 1.10] Properties Udvid tabel caption Represents the caption of the slicer. context The request context associated with the object. This connects the add-in's process to the Office host application's process. height