Last active
May 13, 2025 07:35
-
-
Save aspose-cells-gists/e204d6243cc67d7d255d51c9b85b2c64 to your computer and use it in GitHub Desktop.
Aspose.Cells.GridDesktop for .NET
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| This Gist contains code example snippets for Aspose.Cells.GridDesktop for .NET. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| //Path of the sample Excel file containing Pivot Table | |
| string filePath = Utils.Get_SourceDirectory() + "sampleRenderPivotTableInGridDesktop.xlsx"; | |
| //Import sample Excel file containing Pivot Table | |
| this.gridDesktop1.ImportExcelFile(filePath); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| //Get the version number of GridDesktop | |
| string version = Aspose.Cells.GridDesktop.GridDesktop.GetVersion(); | |
| //Show the version number in message box | |
| MessageBox.Show("GridDesktop Version: " + version, "GridDesktop Version"); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| public class MyICustomColumnCaption : ICustomColumnCaption | |
| { | |
| //Returns the Custom Column Caption | |
| public string GetCaption(int column) | |
| { | |
| return "Mine " + (column + 10); | |
| } | |
| } | |
| public class MyICustomRowCaption : ICustomRowCaption | |
| { | |
| //Returns the Custom Row Caption | |
| public string GetCaption(int row) | |
| { | |
| return "R" + (row + 10).ToString(); | |
| } | |
| } | |
| //------------------------------------------- | |
| //------------------------------------------- | |
| //Access the First GridDesktop Worksheet | |
| Worksheet ws = this.gridDesktop1.Worksheets[0]; | |
| //Assign the Worksheet Custom Column and Row Caption Instance | |
| ws.CustomColumnCaption = new MyICustomColumnCaption(); | |
| ws.CustomRowCaption = new MyICustomRowCaption(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //------------------------------------------------------------------------------ | |
| // <auto-generated> | |
| // 此代码由工具生成。 | |
| // 运行时版本:4.0.30319.42000 | |
| // | |
| // 对此文件的更改可能会导致不正确的行为，并且如果 | |
| // 重新生成代码，这些更改将会丢失。 | |
| // </auto-generated> | |
| //------------------------------------------------------------------------------ | |
| namespace myapp { | |
| using System; | |
| /// <summary> | |
| /// 一个强类型的资源类，用于查找本地化的字符串等。 | |
| /// </summary> | |
| // 此类是由 StronglyTypedResourceBuilder | |
| // 类通过类似于 ResGen 或 Visual Studio 的工具自动生成的。 | |
| // 若要添加或移除成员，请编辑 .ResX 文件，然后重新运行 ResGen | |
| // (以 /str 作为命令选项)，或重新生成 VS 项目。 | |
| [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Resources.Tools.StronglyTypedResourceBuilder", "16.0.0.0")] | |
| [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] | |
| [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()] | |
| internal class customtest { | |
| private static global::System.Resources.ResourceManager resourceMan; | |
| private static global::System.Globalization.CultureInfo resourceCulture; | |
| [global::System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("Microsoft.Performance", "CA1811:AvoidUncalledPrivateCode")] | |
| internal customtest() { | |
| } | |
| /// <summary> | |
| /// 返回此类使用的缓存的 ResourceManager 实例。 | |
| /// </summary> | |
| [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Advanced)] | |
| internal static global::System.Resources.ResourceManager ResourceManager { | |
| get { | |
| if (object.ReferenceEquals(resourceMan, null)) { | |
| global::System.Resources.ResourceManager temp = new global::System.Resources.ResourceManager("testapp.customtest", typeof(customtest).Assembly); | |
| resourceMan = temp; | |
| } | |
| return resourceMan; | |
| } | |
| } | |
| /// <summary> | |
| /// 重写当前线程的 CurrentUICulture 属性，对 | |
| /// 使用此强类型资源类的所有资源查找执行重写。 | |
| /// </summary> | |
| [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Advanced)] | |
| internal static global::System.Globalization.CultureInfo Culture { | |
| get { | |
| return resourceCulture; | |
| } | |
| set { | |
| resourceCulture = value; | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Copy Cells 的本地化字符串。 | |
| /// </summary> | |
| internal static string autofill_copy { | |
| get { | |
| return ResourceManager.GetString("autofill.copy", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Fill Formatting Only 的本地化字符串。 | |
| /// </summary> | |
| internal static string autofill_formatonly { | |
| get { | |
| return ResourceManager.GetString("autofill.formatonly", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Fill Series 的本地化字符串。 | |
| /// </summary> | |
| internal static string autofill_series { | |
| get { | |
| return ResourceManager.GetString("autofill.series", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 To do this,all the merged cells need to be the same size. 的本地化字符串。 | |
| /// </summary> | |
| internal static string autofill_targetcontainmerge { | |
| get { | |
| return ResourceManager.GetString("autofill.targetcontainmerge", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Fill Without Formatting 的本地化字符串。 | |
| /// </summary> | |
| internal static string autofill_withoutformat { | |
| get { | |
| return ResourceManager.GetString("autofill.withoutformat", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Convert to Number 的本地化字符串。 | |
| /// </summary> | |
| internal static string button_convertonumber { | |
| get { | |
| return ResourceManager.GetString("button.convertonumber", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Axis Title 的本地化字符串。 | |
| /// </summary> | |
| internal static string chart_axis_titlename { | |
| get { | |
| return ResourceManager.GetString("chart.axis.titlename", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Billions 的本地化字符串。 | |
| /// </summary> | |
| internal static string chart_axis_unitname_billions { | |
| get { | |
| return ResourceManager.GetString("chart.axis.unitname.billions", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Hundreds 的本地化字符串。 | |
| /// </summary> | |
| internal static string chart_axis_unitname_hundreds { | |
| get { | |
| return ResourceManager.GetString("chart.axis.unitname.hundreds", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Millions 的本地化字符串。 | |
| /// </summary> | |
| internal static string chart_axis_unitname_millions { | |
| get { | |
| return ResourceManager.GetString("chart.axis.unitname.millions", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Thousands 的本地化字符串。 | |
| /// </summary> | |
| internal static string chart_axis_unitname_thousands { | |
| get { | |
| return ResourceManager.GetString("chart.axis.unitname.thousands", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Trillions 的本地化字符串。 | |
| /// </summary> | |
| internal static string chart_axis_unitname_trillions { | |
| get { | |
| return ResourceManager.GetString("chart.axis.unitname.trillions", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Decrease 的本地化字符串。 | |
| /// </summary> | |
| internal static string chart_legend_decreasename { | |
| get { | |
| return ResourceManager.GetString("chart.legend.decreasename", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Increase 的本地化字符串。 | |
| /// </summary> | |
| internal static string chart_legend_increasename { | |
| get { | |
| return ResourceManager.GetString("chart.legend.increasename", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Total 的本地化字符串。 | |
| /// </summary> | |
| internal static string chart_legend_totalname { | |
| get { | |
| return ResourceManager.GetString("chart.legend.totalname", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Other 的本地化字符串。 | |
| /// </summary> | |
| internal static string chart_othername { | |
| get { | |
| return ResourceManager.GetString("chart.othername", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Series 的本地化字符串。 | |
| /// </summary> | |
| internal static string chart_seriesname { | |
| get { | |
| return ResourceManager.GetString("chart.seriesname", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Chart Title 的本地化字符串。 | |
| /// </summary> | |
| internal static string chart_titlename { | |
| get { | |
| return ResourceManager.GetString("chart.titlename", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 clear filter 的本地化字符串。 | |
| /// </summary> | |
| internal static string ck_autofilter_clear { | |
| get { | |
| return ResourceManager.GetString("ck.autofilter.clear", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 number filter,equal,not equal,less,less or equal,greater,greter or equal,between,not between 的本地化字符串。 | |
| /// </summary> | |
| internal static string ck_autofilter_numberfilter_items { | |
| get { | |
| return ResourceManager.GetString("ck.autofilter.numberfilter.items", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Close 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_btn_close { | |
| get { | |
| return ResourceManager.GetString("findreplace.btn.close", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Find &in: 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_btn_findin { | |
| get { | |
| return ResourceManager.GetString("findreplace.btn.findin", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 &Find Next 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_btn_findnext { | |
| get { | |
| return ResourceManager.GetString("findreplace.btn.findnext", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Find options: 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_btn_findoptions { | |
| get { | |
| return ResourceManager.GetString("findreplace.btn.findoptions", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Find / Replace 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_btn_findreplace { | |
| get { | |
| return ResourceManager.GetString("findreplace.btn.findreplace", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Fi&nd what: 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_btn_findwhat { | |
| get { | |
| return ResourceManager.GetString("findreplace.btn.findwhat", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Match &case 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_btn_matchcase { | |
| get { | |
| return ResourceManager.GetString("findreplace.btn.matchcase", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Match &whole word 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_btn_matchwhole { | |
| get { | |
| return ResourceManager.GetString("findreplace.btn.matchwhole", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Regular &expression 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_btn_regular { | |
| get { | |
| return ResourceManager.GetString("findreplace.btn.regular", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 &Replace 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_btn_replace { | |
| get { | |
| return ResourceManager.GetString("findreplace.btn.replace", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Replace &All 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_btn_replaceall { | |
| get { | |
| return ResourceManager.GetString("findreplace.btn.replaceall", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Re&place with: 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_btn_replacewith { | |
| get { | |
| return ResourceManager.GetString("findreplace.btn.replacewith", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Search &up 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_btn_searchup { | |
| get { | |
| return ResourceManager.GetString("findreplace.btn.searchup", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Please input what will be searched! 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_msg_find { | |
| get { | |
| return ResourceManager.GetString("findreplace.msg.find", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 The specified text was not found! 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_msg_findfail { | |
| get { | |
| return ResourceManager.GetString("findreplace.msg.findfail", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 The search has been completed. 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_msg_findfinish { | |
| get { | |
| return ResourceManager.GetString("findreplace.msg.findfinish", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 The specified text was not found or the cells are read only! 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_msg_replaceallfail { | |
| get { | |
| return ResourceManager.GetString("findreplace.msg.replaceallfail", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 The specified text was not found or the cell is read only! 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_msg_replacefail { | |
| get { | |
| return ResourceManager.GetString("findreplace.msg.replacefail", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 The search has been completed and {0} replacement has been made. 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_msg_replaces1 { | |
| get { | |
| return ResourceManager.GetString("findreplace.msg.replaces1", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 The search has been completed and {0} replacements have been made. 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_msg_replaces2 { | |
| get { | |
| return ResourceManager.GetString("findreplace.msg.replaces2", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 And there are some cells can not be replaced! 的本地化字符串。 | |
| /// </summary> | |
| internal static string findreplace_msg_replacespart { | |
| get { | |
| return ResourceManager.GetString("findreplace.msg.replacespart", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Cancel 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtcomment_cancel { | |
| get { | |
| return ResourceManager.GetString("fmtcomment.cancel", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Font: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtcomment_font { | |
| get { | |
| return ResourceManager.GetString("fmtcomment.font", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Color: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtcomment_fontcolor { | |
| get { | |
| return ResourceManager.GetString("fmtcomment.fontcolor", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Size: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtcomment_fontsize { | |
| get { | |
| return ResourceManager.GetString("fmtcomment.fontsize", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Style: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtcomment_fontstyle { | |
| get { | |
| return ResourceManager.GetString("fmtcomment.fontstyle", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Format Comment 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtcomment_formatcomment { | |
| get { | |
| return ResourceManager.GetString("fmtcomment.formatcomment", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Ok 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtcomment_ok { | |
| get { | |
| return ResourceManager.GetString("fmtcomment.ok", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Preview 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtcomment_preview { | |
| get { | |
| return ResourceManager.GetString("fmtcomment.preview", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Strikethrough 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtcomment_strikethrough { | |
| get { | |
| return ResourceManager.GetString("fmtcomment.strikethrough", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Underline 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtcomment_underline { | |
| get { | |
| return ResourceManager.GetString("fmtcomment.underline", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Alignment 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_alignment { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.alignment", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Border 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_border { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.border", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Bottom 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_bottom { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.bottom", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Category: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_category { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.category", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 CellColor: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_cellcolor { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.cellcolor", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Color: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_color { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.color", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Decimal places: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_decimalplaces { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.decimalplaces", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 DiagonalDown 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_diagonaldown { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.diagonaldown", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 DiagonalUp 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_diagonalup { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.diagonalup", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Font 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_font { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.font", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Font Color: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_fontcolor { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.fontcolor", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Font size: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_fontsize { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.fontsize", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Font style: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_fontstyle { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.fontstyle", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Format Cells 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_formatcells { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.formatcells", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Hidden 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_hidden { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.hidden", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Horizontal: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_horizontal { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.horizontal", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Left 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_left { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.left", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Line 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_line { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.line", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Locale: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_locale { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.locale", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Locked 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_locked { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.locked", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 General,Number,Currency,Accounting,Date,Time,Percentage,Scientific,Text,Custom 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_lstCategory { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.lstCategory", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Accounting formats line up the currency symbols and decimal points in a column. 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_lstCategory_acount { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.lstCategory.acount", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Currency formats are used for general monetary values. Use Accounting formats to align decimal points in a column. 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_lstCategory_currency { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.lstCategory.currency", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Type the number format code,using one of the existing codes as a starting point. 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_lstCategory_custom { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.lstCategory.custom", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Date formats display date and time serial numbers as date values.Except for items that have an asterisk (*),applied formats do not switch date orders with the operating system. 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_lstCategory_data { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.lstCategory.data", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 General format cells have no specific number format. 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_lstCategory_general { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.lstCategory.general", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Number is used for general display of numbers. Currency and Accounting offer specialized formatting for monetary value. 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_lstCategory_number { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.lstCategory.number", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Percentage formats multiply the cell value by 100 and displays the result with a percent symbol. 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_lstCategory_percentage { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.lstCategory.percentage", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Text format cells are treated as text even when a number is in the cell.The cell is displayed exactly as entered. 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_lstCategory_text { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.lstCategory.text", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Time formats display date and time serial numbers as time values. Except for items that have an asterisk (*), applied formats do not switch date or time orders with the operating system. 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_lstCategory_time { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.lstCategory.time", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Merge cells 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_mergecells { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.mergecells", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Negative Number: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_negative { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.negative", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 &None 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_none { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.none", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Number 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_number { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.number", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 &Outline 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_outline { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.outline", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Presets 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_presets { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.presets", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Preview 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_preview { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.preview", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Protection 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_protection { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.protection", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Right 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_right { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.right", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Sample 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_sample { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.sample", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Shrink to fit 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_shrink { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.shrink", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Strikethrough 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_strikethrough { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.strikethrough", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Symbol: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_symbol { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.symbol", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Text alignment 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_textalignment { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.textalignment", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 General,Left,Center,Right 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_textalignment_halign { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.textalignment.halign", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Top,Center,Bottom 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_textalignment_valign { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.textalignment.valign", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Text control 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_textcontrol { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.textcontrol", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Top 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_top { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.top", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Type: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_type { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.type", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Underline 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_underline { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.underline", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Use 1000 Separator(,) 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_use1000 { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.use1000", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Vertical: 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_vertical { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.vertical", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Wrap text 的本地化字符串。 | |
| /// </summary> | |
| internal static string fmtstyle_wrap { | |
| get { | |
| return ResourceManager.GetString("fmtstyle.wrap", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Address: 的本地化字符串。 | |
| /// </summary> | |
| internal static string hyperlink_address { | |
| get { | |
| return ResourceManager.GetString("hyperlink.address", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Browse for File 的本地化字符串。 | |
| /// </summary> | |
| internal static string hyperlink_browsefile { | |
| get { | |
| return ResourceManager.GetString("hyperlink.browsefile", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Browse for Folder 的本地化字符串。 | |
| /// </summary> | |
| internal static string hyperlink_browsefolder { | |
| get { | |
| return ResourceManager.GetString("hyperlink.browsefolder", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Link to File 的本地化字符串。 | |
| /// </summary> | |
| internal static string hyperlink_linkfile { | |
| get { | |
| return ResourceManager.GetString("hyperlink.linkfile", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Hyperlink 的本地化字符串。 | |
| /// </summary> | |
| internal static string hyperlink_name { | |
| get { | |
| return ResourceManager.GetString("hyperlink.name", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Please input address! 的本地化字符串。 | |
| /// </summary> | |
| internal static string hyperlink_pleaseinput { | |
| get { | |
| return ResourceManager.GetString("hyperlink.pleaseinput", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Text to display: 的本地化字符串。 | |
| /// </summary> | |
| internal static string hyperlink_texttodisplay { | |
| get { | |
| return ResourceManager.GetString("hyperlink.texttodisplay", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 &Add Row 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_addrow { | |
| get { | |
| return ResourceManager.GetString("menu.addrow", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 All 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_all { | |
| get { | |
| return ResourceManager.GetString("menu.all", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Cancel 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_cancel { | |
| get { | |
| return ResourceManager.GetString("menu.cancel", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Clear Co&ntents 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_clearcontent { | |
| get { | |
| return ResourceManager.GetString("menu.clearcontent", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 &Copy 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_copy { | |
| get { | |
| return ResourceManager.GetString("menu.copy", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Cu&t 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_cut { | |
| get { | |
| return ResourceManager.GetString("menu.cut", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 &Delete 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_del { | |
| get { | |
| return ResourceManager.GetString("menu.del", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Delete Column 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_delcol { | |
| get { | |
| return ResourceManager.GetString("menu.delcol", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Delete Co&mment 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_delcomment { | |
| get { | |
| return ResourceManager.GetString("menu.delcomment", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Delete Row 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_delrow { | |
| get { | |
| return ResourceManager.GetString("menu.delrow", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Edit Hyperlink... 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_edithyperlink { | |
| get { | |
| return ResourceManager.GetString("menu.edithyperlink", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 &Format Cells... 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_formatcell { | |
| get { | |
| return ResourceManager.GetString("menu.formatcell", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Hide 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_hide { | |
| get { | |
| return ResourceManager.GetString("menu.hide", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Hyperlink... 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_hyperlink { | |
| get { | |
| return ResourceManager.GetString("menu.hyperlink", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 &Insert 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_insert { | |
| get { | |
| return ResourceManager.GetString("menu.insert", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Insert Column 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_insertcol { | |
| get { | |
| return ResourceManager.GetString("menu.insertcol", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Insert Co&mment 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_insertcomment { | |
| get { | |
| return ResourceManager.GetString("menu.insertcomment", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Insert Hyperlink 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_inserthyperlink { | |
| get { | |
| return ResourceManager.GetString("menu.inserthyperlink", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Insert Row 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_insertrow { | |
| get { | |
| return ResourceManager.GetString("menu.insertrow", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 OK 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_ok { | |
| get { | |
| return ResourceManager.GetString("menu.ok", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 &Open Hyperlink 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_openhyperlink { | |
| get { | |
| return ResourceManager.GetString("menu.openhyperlink", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 &Paste 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_paste { | |
| get { | |
| return ResourceManager.GetString("menu.paste", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 &Remove Hyperlink 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_removehyperlink { | |
| get { | |
| return ResourceManager.GetString("menu.removehyperlink", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Rename 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_rename { | |
| get { | |
| return ResourceManager.GetString("menu.rename", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 UnHide 的本地化字符串。 | |
| /// </summary> | |
| internal static string menu_unhide { | |
| get { | |
| return ResourceManager.GetString("menu.unhide", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 the worksheet name is invalid. 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_copy_invalidsheetname { | |
| get { | |
| return ResourceManager.GetString("msg.copy.invalidsheetname", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 The cell or chart you're trying to change is on a protected sheet.To make a change,unprotect the sheet.You might be requested to enter a password. 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_copy_protectsheet { | |
| get { | |
| return ResourceManager.GetString("msg.copy.protectsheet", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 That command cannot be used on multiple selections. 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_copy_unsupportrange { | |
| get { | |
| return ResourceManager.GetString("msg.copy.unsupportrange", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 That command cannot be used on multiple selections. 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_del_multipleselection { | |
| get { | |
| return ResourceManager.GetString("msg.del.multipleselection", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 That name is already taken,Try a diffrent one 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_duplicatename { | |
| get { | |
| return ResourceManager.GetString("msg.duplicatename", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Please enter correct number for filter 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_filternumber_invalid { | |
| get { | |
| return ResourceManager.GetString("msg.filternumber.invalid", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 The address is not valid. 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_hyperlink_invalidaddress { | |
| get { | |
| return ResourceManager.GetString("msg.hyperlink.invalidaddress", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Invalid passowrd,the password can not be empty string. 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_invalidpassword { | |
| get { | |
| return ResourceManager.GetString("msg.invalidpassword", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 The password for write protection you supplied is not correct.\nThe file is open as readonly. 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_invalidpassword_writeprotect { | |
| get { | |
| return ResourceManager.GetString("msg.invalidpassword.writeprotect", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 The sheet is invisible,you can not set it to active. 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_invisiblesheet { | |
| get { | |
| return ResourceManager.GetString("msg.invisiblesheet", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 PageRows is out of range,we don't support rows more than 10000 per page.\nPlease hava a retry. 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_pagerows_limitation { | |
| get { | |
| return ResourceManager.GetString("msg.pagerows.limitation", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Page number is out of range,we don't support pages more than 5000.\nPlease try increase pagerows. 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_pages_limitation { | |
| get { | |
| return ResourceManager.GetString("msg.pages.limitation", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Please input password! 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_password_input { | |
| get { | |
| return ResourceManager.GetString("msg.password.input", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 The password for write protection you supplied is not correct. 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_password_invalid { | |
| get { | |
| return ResourceManager.GetString("msg.password.invalid", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 The information cannot be pasted because the Copy area and the paste area are not the same size and shape. 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_paste_notsamerange { | |
| get { | |
| return ResourceManager.GetString("msg.paste.notsamerange", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 The cell or chart you're trying to change is on a protected sheet.To make a change,unprotect the sheet.You might be requested to enter a password 的本地化字符串。 | |
| /// </summary> | |
| internal static string msg_paste_protectsheet { | |
| get { | |
| return ResourceManager.GetString("msg.paste.protectsheet", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 (All) 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_allname { | |
| get { | |
| return ResourceManager.GetString("pivot.allname", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Column Labels 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_columnlabels { | |
| get { | |
| return ResourceManager.GetString("pivot.columnlabels", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Data 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_datafieldheader { | |
| get { | |
| return ResourceManager.GetString("pivot.datafieldheader", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 (blank) 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_emptydataname { | |
| get { | |
| return ResourceManager.GetString("pivot.emptydataname", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Grand Total 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_grandtotalname { | |
| get { | |
| return ResourceManager.GetString("pivot.grandtotalname", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 (Multiple Items) 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_multipleitemsname { | |
| get { | |
| return ResourceManager.GetString("pivot.multipleitemsname", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Values 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_protectionname { | |
| get { | |
| return ResourceManager.GetString("pivot.protectionname", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Row Labels 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_rowlabels { | |
| get { | |
| return ResourceManager.GetString("pivot.rowlabels", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Total 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_subtotalname { | |
| get { | |
| return ResourceManager.GetString("pivot.subtotalname", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Average 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_subtotaltype_average { | |
| get { | |
| return ResourceManager.GetString("pivot.subtotaltype.average", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Count 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_subtotaltype_count { | |
| get { | |
| return ResourceManager.GetString("pivot.subtotaltype.count", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Count 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_subtotaltype_countnums { | |
| get { | |
| return ResourceManager.GetString("pivot.subtotaltype.countnums", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Max 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_subtotaltype_max { | |
| get { | |
| return ResourceManager.GetString("pivot.subtotaltype.max", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Min 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_subtotaltype_min { | |
| get { | |
| return ResourceManager.GetString("pivot.subtotaltype.min", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Product 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_subtotaltype_product { | |
| get { | |
| return ResourceManager.GetString("pivot.subtotaltype.product", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 StdDev 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_subtotaltype_stdev { | |
| get { | |
| return ResourceManager.GetString("pivot.subtotaltype.stdev", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 StdDevp 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_subtotaltype_stdevp { | |
| get { | |
| return ResourceManager.GetString("pivot.subtotaltype.stdevp", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Sum 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_subtotaltype_sum { | |
| get { | |
| return ResourceManager.GetString("pivot.subtotaltype.sum", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Var 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_subtotaltype_var { | |
| get { | |
| return ResourceManager.GetString("pivot.subtotaltype.var", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Varp 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_subtotaltype_varp { | |
| get { | |
| return ResourceManager.GetString("pivot.subtotaltype.varp", resourceCulture); | |
| } | |
| } | |
| /// <summary> | |
| /// 查找类似 Total 的本地化字符串。 | |
| /// </summary> | |
| internal static string pivot_totalname { | |
| get { | |
| return ResourceManager.GetString("pivot.totalname", resourceCulture); | |
| } | |
| } | |
| } | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="utf-8"?> | |
| <root> | |
| <!-- | |
| Microsoft ResX Schema | |
| Version 2.0 | |
| The primary goals of this format is to allow a simple XML format | |
| that is mostly human readable. The generation and parsing of the | |
| various data types are done through the TypeConverter classes | |
| associated with the data types. | |
| Example: | |
| ... ado.net/XML headers & schema ... | |
| <resheader name="resmimetype">text/microsoft-resx</resheader> | |
| <resheader name="version">2.0</resheader> | |
| <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader> | |
| <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader> | |
| <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data> | |
| <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data> | |
| <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64"> | |
| <value>[base64 mime encoded serialized .NET Framework object]</value> | |
| </data> | |
| <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> | |
| <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value> | |
| <comment>This is a comment</comment> | |
| </data> | |
| There are any number of "resheader" rows that contain simple | |
| name/value pairs. | |
| Each data row contains a name, and value. The row also contains a | |
| type or mimetype. Type corresponds to a .NET class that support | |
| text/value conversion through the TypeConverter architecture. | |
| Classes that don't support this are serialized and stored with the | |
| mimetype set. | |
| The mimetype is used for serialized objects, and tells the | |
| ResXResourceReader how to depersist the object. This is currently not | |
| extensible. For a given mimetype the value must be set accordingly: | |
| Note - application/x-microsoft.net.object.binary.base64 is the format | |
| that the ResXResourceWriter will generate, however the reader can | |
| read any of the formats listed below. | |
| mimetype: application/x-microsoft.net.object.binary.base64 | |
| value : The object must be serialized with | |
| : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter | |
| : and then encoded with base64 encoding. | |
| mimetype: application/x-microsoft.net.object.soap.base64 | |
| value : The object must be serialized with | |
| : System.Runtime.Serialization.Formatters.Soap.SoapFormatter | |
| : and then encoded with base64 encoding. | |
| mimetype: application/x-microsoft.net.object.bytearray.base64 | |
| value : The object must be serialized into a byte array | |
| : using a System.ComponentModel.TypeConverter | |
| : and then encoded with base64 encoding. | |
| --> | |
| <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> | |
| <xsd:import namespace="http://www.w3.org/XML/1998/namespace" /> | |
| <xsd:element name="root" msdata:IsDataSet="true"> | |
| <xsd:complexType> | |
| <xsd:choice maxOccurs="unbounded"> | |
| <xsd:element name="metadata"> | |
| <xsd:complexType> | |
| <xsd:sequence> | |
| <xsd:element name="value" type="xsd:string" minOccurs="0" /> | |
| </xsd:sequence> | |
| <xsd:attribute name="name" use="required" type="xsd:string" /> | |
| <xsd:attribute name="type" type="xsd:string" /> | |
| <xsd:attribute name="mimetype" type="xsd:string" /> | |
| <xsd:attribute ref="xml:space" /> | |
| </xsd:complexType> | |
| </xsd:element> | |
| <xsd:element name="assembly"> | |
| <xsd:complexType> | |
| <xsd:attribute name="alias" type="xsd:string" /> | |
| <xsd:attribute name="name" type="xsd:string" /> | |
| </xsd:complexType> | |
| </xsd:element> | |
| <xsd:element name="data"> | |
| <xsd:complexType> | |
| <xsd:sequence> | |
| <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" /> | |
| <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" /> | |
| </xsd:sequence> | |
| <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" /> | |
| <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" /> | |
| <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" /> | |
| <xsd:attribute ref="xml:space" /> | |
| </xsd:complexType> | |
| </xsd:element> | |
| <xsd:element name="resheader"> | |
| <xsd:complexType> | |
| <xsd:sequence> | |
| <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" /> | |
| </xsd:sequence> | |
| <xsd:attribute name="name" type="xsd:string" use="required" /> | |
| </xsd:complexType> | |
| </xsd:element> | |
| </xsd:choice> | |
| </xsd:complexType> | |
| </xsd:element> | |
| </xsd:schema> | |
| <resheader name="resmimetype"> | |
| <value>text/microsoft-resx</value> | |
| </resheader> | |
| <resheader name="version"> | |
| <value>2.0</value> | |
| </resheader> | |
| <resheader name="reader"> | |
| <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value> | |
| </resheader> | |
| <resheader name="writer"> | |
| <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value> | |
| </resheader> | |
| <data name="autofill.copy" xml:space="preserve"> | |
| <value>Copy Cells</value> | |
| </data> | |
| <data name="autofill.formatonly" xml:space="preserve"> | |
| <value>Fill Formatting Only</value> | |
| </data> | |
| <data name="autofill.series" xml:space="preserve"> | |
| <value>Fill Series</value> | |
| </data> | |
| <data name="autofill.targetcontainmerge" xml:space="preserve"> | |
| <value>To do this,all the merged cells need to be the same size.</value> | |
| </data> | |
| <data name="autofill.withoutformat" xml:space="preserve"> | |
| <value>Fill Without Formatting</value> | |
| </data> | |
| <data name="button.convertonumber" xml:space="preserve"> | |
| <value>Convert to Number</value> | |
| </data> | |
| <data name="chart.axis.titlename" xml:space="preserve"> | |
| <value>Axis Title</value> | |
| </data> | |
| <data name="chart.axis.unitname.billions" xml:space="preserve"> | |
| <value>Billions</value> | |
| </data> | |
| <data name="chart.axis.unitname.hundreds" xml:space="preserve"> | |
| <value>Hundreds</value> | |
| </data> | |
| <data name="chart.axis.unitname.millions" xml:space="preserve"> | |
| <value>Millions</value> | |
| </data> | |
| <data name="chart.axis.unitname.thousands" xml:space="preserve"> | |
| <value>Thousands</value> | |
| </data> | |
| <data name="chart.axis.unitname.trillions" xml:space="preserve"> | |
| <value>Trillions</value> | |
| </data> | |
| <data name="chart.legend.decreasename" xml:space="preserve"> | |
| <value>Decrease</value> | |
| </data> | |
| <data name="chart.legend.increasename" xml:space="preserve"> | |
| <value>Increase</value> | |
| </data> | |
| <data name="chart.legend.totalname" xml:space="preserve"> | |
| <value>Total</value> | |
| </data> | |
| <data name="chart.othername" xml:space="preserve"> | |
| <value>Other</value> | |
| </data> | |
| <data name="chart.seriesname" xml:space="preserve"> | |
| <value>Series</value> | |
| </data> | |
| <data name="chart.titlename" xml:space="preserve"> | |
| <value>Chart Title</value> | |
| </data> | |
| <data name="ck.autofilter.clear" xml:space="preserve"> | |
| <value>clear filter</value> | |
| </data> | |
| <data name="ck.autofilter.datefilter.items" xml:space="preserve"> | |
| <value>Date Filter,Equals,Before,After,Between</value> | |
| </data> | |
| <data name="ck.autofilter.numberfilter.items" xml:space="preserve"> | |
| <value>Number Filter,Equals,Not Equals,Less,Less Or Equals,Greater,Greter Or Equasl,Between,Not Between,Top 10</value> | |
| </data> | |
| <data name="ck.autofilter.numberfilter.top10opt1" xml:space="preserve"> | |
| <value>Top,Bottom</value> | |
| </data> | |
| <data name="ck.autofilter.numberfilter.top10opt2" xml:space="preserve"> | |
| <value>Items,Percent</value> | |
| </data> | |
| <data name="ck.autofilter.textfilter.items" xml:space="preserve"> | |
| <value>Text Filter,Equals,Not Equals,Begins With,Ends With,Contains,Not Contains</value> | |
| </data> | |
| <data name="findreplace.btn.close" xml:space="preserve"> | |
| <value>Close</value> | |
| </data> | |
| <data name="findreplace.btn.findin" xml:space="preserve"> | |
| <value>Find &in:</value> | |
| </data> | |
| <data name="findreplace.btn.findnext" xml:space="preserve"> | |
| <value>&Find Next</value> | |
| </data> | |
| <data name="findreplace.btn.findoptions" xml:space="preserve"> | |
| <value>Find options:</value> | |
| </data> | |
| <data name="findreplace.btn.findreplace" xml:space="preserve"> | |
| <value>Find / Replace</value> | |
| </data> | |
| <data name="findreplace.btn.findwhat" xml:space="preserve"> | |
| <value>Fi&nd what:</value> | |
| </data> | |
| <data name="findreplace.btn.matchcase" xml:space="preserve"> | |
| <value>Match &case</value> | |
| </data> | |
| <data name="findreplace.btn.matchwhole" xml:space="preserve"> | |
| <value>Match &whole word</value> | |
| </data> | |
| <data name="findreplace.btn.regular" xml:space="preserve"> | |
| <value>Regular &expression</value> | |
| </data> | |
| <data name="findreplace.btn.replace" xml:space="preserve"> | |
| <value>&Replace</value> | |
| </data> | |
| <data name="findreplace.btn.replaceall" xml:space="preserve"> | |
| <value>Replace &All</value> | |
| </data> | |
| <data name="findreplace.btn.replacewith" xml:space="preserve"> | |
| <value>Re&place with:</value> | |
| </data> | |
| <data name="findreplace.btn.searchup" xml:space="preserve"> | |
| <value>Search &up</value> | |
| </data> | |
| <data name="findreplace.msg.find" xml:space="preserve"> | |
| <value>Please input what will be searched!</value> | |
| </data> | |
| <data name="findreplace.msg.findfail" xml:space="preserve"> | |
| <value>The specified text was not found!</value> | |
| </data> | |
| <data name="findreplace.msg.findfinish" xml:space="preserve"> | |
| <value>The search has been completed.</value> | |
| </data> | |
| <data name="findreplace.msg.replaceallfail" xml:space="preserve"> | |
| <value>The specified text was not found or the cells are read only!</value> | |
| </data> | |
| <data name="findreplace.msg.replacefail" xml:space="preserve"> | |
| <value>The specified text was not found or the cell is read only!</value> | |
| </data> | |
| <data name="findreplace.msg.replaces1" xml:space="preserve"> | |
| <value>The search has been completed and {0} replacement has been made.</value> | |
| </data> | |
| <data name="findreplace.msg.replaces2" xml:space="preserve"> | |
| <value>The search has been completed and {0} replacements have been made.</value> | |
| </data> | |
| <data name="findreplace.msg.replacespart" xml:space="preserve"> | |
| <value>And there are some cells can not be replaced!</value> | |
| </data> | |
| <data name="fmtcomment.cancel" xml:space="preserve"> | |
| <value>Cancel</value> | |
| </data> | |
| <data name="fmtcomment.font" xml:space="preserve"> | |
| <value>Font:</value> | |
| </data> | |
| <data name="fmtcomment.fontcolor" xml:space="preserve"> | |
| <value>Color:</value> | |
| </data> | |
| <data name="fmtcomment.fontsize" xml:space="preserve"> | |
| <value>Size:</value> | |
| </data> | |
| <data name="fmtcomment.fontstyle" xml:space="preserve"> | |
| <value>Style:</value> | |
| </data> | |
| <data name="fmtcomment.formatcomment" xml:space="preserve"> | |
| <value>Format Comment</value> | |
| </data> | |
| <data name="fmtcomment.ok" xml:space="preserve"> | |
| <value>Ok</value> | |
| </data> | |
| <data name="fmtcomment.preview" xml:space="preserve"> | |
| <value>Preview</value> | |
| </data> | |
| <data name="fmtcomment.strikethrough" xml:space="preserve"> | |
| <value>Strikethrough</value> | |
| </data> | |
| <data name="fmtcomment.underline" xml:space="preserve"> | |
| <value>Underline</value> | |
| </data> | |
| <data name="fmtstyle.alignment" xml:space="preserve"> | |
| <value>Alignment</value> | |
| </data> | |
| <data name="fmtstyle.border" xml:space="preserve"> | |
| <value>Border</value> | |
| </data> | |
| <data name="fmtstyle.bottom" xml:space="preserve"> | |
| <value>Bottom</value> | |
| </data> | |
| <data name="fmtstyle.category" xml:space="preserve"> | |
| <value>Category:</value> | |
| </data> | |
| <data name="fmtstyle.cellcolor" xml:space="preserve"> | |
| <value>CellColor:</value> | |
| </data> | |
| <data name="fmtstyle.color" xml:space="preserve"> | |
| <value>Color:</value> | |
| </data> | |
| <data name="fmtstyle.decimalplaces" xml:space="preserve"> | |
| <value>Decimal places:</value> | |
| </data> | |
| <data name="fmtstyle.diagonaldown" xml:space="preserve"> | |
| <value>DiagonalDown</value> | |
| </data> | |
| <data name="fmtstyle.diagonalup" xml:space="preserve"> | |
| <value>DiagonalUp</value> | |
| </data> | |
| <data name="fmtstyle.font" xml:space="preserve"> | |
| <value>Font</value> | |
| </data> | |
| <data name="fmtstyle.fontcolor" xml:space="preserve"> | |
| <value>Font Color:</value> | |
| </data> | |
| <data name="fmtstyle.fontsize" xml:space="preserve"> | |
| <value>Font size:</value> | |
| </data> | |
| <data name="fmtstyle.fontstyle" xml:space="preserve"> | |
| <value>Font style:</value> | |
| </data> | |
| <data name="fmtstyle.formatcells" xml:space="preserve"> | |
| <value>Format Cells</value> | |
| </data> | |
| <data name="fmtstyle.hidden" xml:space="preserve"> | |
| <value>Hidden</value> | |
| </data> | |
| <data name="fmtstyle.horizontal" xml:space="preserve"> | |
| <value>Horizontal:</value> | |
| </data> | |
| <data name="fmtstyle.left" xml:space="preserve"> | |
| <value>Left</value> | |
| </data> | |
| <data name="fmtstyle.line" xml:space="preserve"> | |
| <value>Line</value> | |
| </data> | |
| <data name="fmtstyle.locale" xml:space="preserve"> | |
| <value>Locale:</value> | |
| </data> | |
| <data name="fmtstyle.locked" xml:space="preserve"> | |
| <value>Locked</value> | |
| </data> | |
| <data name="fmtstyle.lstCategory" xml:space="preserve"> | |
| <value>General,Number,Currency,Accounting,Date,Time,Percentage,Scientific,Text,Custom</value> | |
| </data> | |
| <data name="fmtstyle.lstCategory.acount" xml:space="preserve"> | |
| <value>Accounting formats line up the currency symbols and decimal points in a column.</value> | |
| </data> | |
| <data name="fmtstyle.lstCategory.currency" xml:space="preserve"> | |
| <value>Currency formats are used for general monetary values. Use Accounting formats to align decimal points in a column.</value> | |
| </data> | |
| <data name="fmtstyle.lstCategory.custom" xml:space="preserve"> | |
| <value>Type the number format code,using one of the existing codes as a starting point.</value> | |
| </data> | |
| <data name="fmtstyle.lstCategory.data" xml:space="preserve"> | |
| <value>Date formats display date and time serial numbers as date values.Except for items that have an asterisk (*),applied formats do not switch date orders with the operating system.</value> | |
| </data> | |
| <data name="fmtstyle.lstCategory.general" xml:space="preserve"> | |
| <value>General format cells have no specific number format.</value> | |
| </data> | |
| <data name="fmtstyle.lstCategory.number" xml:space="preserve"> | |
| <value>Number is used for general display of numbers. Currency and Accounting offer specialized formatting for monetary value.</value> | |
| </data> | |
| <data name="fmtstyle.lstCategory.percentage" xml:space="preserve"> | |
| <value>Percentage formats multiply the cell value by 100 and displays the result with a percent symbol.</value> | |
| </data> | |
| <data name="fmtstyle.lstCategory.text" xml:space="preserve"> | |
| <value>Text format cells are treated as text even when a number is in the cell.The cell is displayed exactly as entered.</value> | |
| </data> | |
| <data name="fmtstyle.lstCategory.time" xml:space="preserve"> | |
| <value>Time formats display date and time serial numbers as time values. Except for items that have an asterisk (*), applied formats do not switch date or time orders with the operating system.</value> | |
| </data> | |
| <data name="fmtstyle.mergecells" xml:space="preserve"> | |
| <value>Merge cells</value> | |
| </data> | |
| <data name="fmtstyle.negative" xml:space="preserve"> | |
| <value>Negative Number:</value> | |
| </data> | |
| <data name="fmtstyle.none" xml:space="preserve"> | |
| <value>&None</value> | |
| </data> | |
| <data name="fmtstyle.number" xml:space="preserve"> | |
| <value>Number</value> | |
| </data> | |
| <data name="fmtstyle.outline" xml:space="preserve"> | |
| <value>&Outline</value> | |
| </data> | |
| <data name="fmtstyle.presets" xml:space="preserve"> | |
| <value>Presets</value> | |
| </data> | |
| <data name="fmtstyle.preview" xml:space="preserve"> | |
| <value>Preview</value> | |
| </data> | |
| <data name="fmtstyle.protection" xml:space="preserve"> | |
| <value>Protection</value> | |
| </data> | |
| <data name="fmtstyle.right" xml:space="preserve"> | |
| <value>Right</value> | |
| </data> | |
| <data name="fmtstyle.sample" xml:space="preserve"> | |
| <value>Sample</value> | |
| </data> | |
| <data name="fmtstyle.shrink" xml:space="preserve"> | |
| <value>Shrink to fit</value> | |
| </data> | |
| <data name="fmtstyle.strikethrough" xml:space="preserve"> | |
| <value>Strikethrough</value> | |
| </data> | |
| <data name="fmtstyle.symbol" xml:space="preserve"> | |
| <value>Symbol:</value> | |
| </data> | |
| <data name="fmtstyle.textalignment" xml:space="preserve"> | |
| <value>Text alignment</value> | |
| </data> | |
| <data name="fmtstyle.textalignment.halign" xml:space="preserve"> | |
| <value>General,Left,Center,Right</value> | |
| </data> | |
| <data name="fmtstyle.textalignment.valign" xml:space="preserve"> | |
| <value>Top,Center,Bottom</value> | |
| </data> | |
| <data name="fmtstyle.textcontrol" xml:space="preserve"> | |
| <value>Text control</value> | |
| </data> | |
| <data name="fmtstyle.top" xml:space="preserve"> | |
| <value>Top</value> | |
| </data> | |
| <data name="fmtstyle.type" xml:space="preserve"> | |
| <value>Type:</value> | |
| </data> | |
| <data name="fmtstyle.underline" xml:space="preserve"> | |
| <value>Underline</value> | |
| </data> | |
| <data name="fmtstyle.use1000" xml:space="preserve"> | |
| <value>Use 1000 Separator(,)</value> | |
| </data> | |
| <data name="fmtstyle.vertical" xml:space="preserve"> | |
| <value>Vertical:</value> | |
| </data> | |
| <data name="fmtstyle.wrap" xml:space="preserve"> | |
| <value>Wrap text</value> | |
| </data> | |
| <data name="hyperlink.address" xml:space="preserve"> | |
| <value>Address:</value> | |
| </data> | |
| <data name="hyperlink.browsefile" xml:space="preserve"> | |
| <value>Browse for File</value> | |
| </data> | |
| <data name="hyperlink.browsefolder" xml:space="preserve"> | |
| <value>Browse for Folder</value> | |
| </data> | |
| <data name="hyperlink.linkfile" xml:space="preserve"> | |
| <value>Link to File</value> | |
| </data> | |
| <data name="hyperlink.name" xml:space="preserve"> | |
| <value>Hyperlink</value> | |
| </data> | |
| <data name="hyperlink.pleaseinput" xml:space="preserve"> | |
| <value>Please input address!</value> | |
| </data> | |
| <data name="hyperlink.texttodisplay" xml:space="preserve"> | |
| <value>Text to display:</value> | |
| </data> | |
| <data name="menu.addrow" xml:space="preserve"> | |
| <value>&Add Row</value> | |
| </data> | |
| <data name="menu.all" xml:space="preserve"> | |
| <value>所有</value> | |
| </data> | |
| <data name="menu.cancel" xml:space="preserve"> | |
| <value>取消</value> | |
| </data> | |
| <data name="menu.clearcontent" xml:space="preserve"> | |
| <value>清除内容</value> | |
| </data> | |
| <data name="menu.copy" xml:space="preserve"> | |
| <value>复制</value> | |
| </data> | |
| <data name="menu.cut" xml:space="preserve"> | |
| <value>剪切</value> | |
| </data> | |
| <data name="menu.del" xml:space="preserve"> | |
| <value>删除</value> | |
| </data> | |
| <data name="menu.delcol" xml:space="preserve"> | |
| <value>删除列</value> | |
| </data> | |
| <data name="menu.delcomment" xml:space="preserve"> | |
| <value>删除注释</value> | |
| </data> | |
| <data name="menu.delrow" xml:space="preserve"> | |
| <value>删除行</value> | |
| </data> | |
| <data name="menu.edithyperlink" xml:space="preserve"> | |
| <value>编辑链接...</value> | |
| </data> | |
| <data name="menu.formatcell" xml:space="preserve"> | |
| <value>格式化...</value> | |
| </data> | |
| <data name="menu.hide" xml:space="preserve"> | |
| <value>隐藏</value> | |
| </data> | |
| <data name="menu.hyperlink" xml:space="preserve"> | |
| <value>链接...</value> | |
| </data> | |
| <data name="menu.insert" xml:space="preserve"> | |
| <value>插入</value> | |
| </data> | |
| <data name="menu.insertcol" xml:space="preserve"> | |
| <value>插入列</value> | |
| </data> | |
| <data name="menu.insertcomment" xml:space="preserve"> | |
| <value>添加注释</value> | |
| </data> | |
| <data name="menu.inserthyperlink" xml:space="preserve"> | |
| <value>添加链接</value> | |
| </data> | |
| <data name="menu.insertrow" xml:space="preserve"> | |
| <value>插入行</value> | |
| </data> | |
| <data name="menu.ok" xml:space="preserve"> | |
| <value>确定</value> | |
| </data> | |
| <data name="menu.openhyperlink" xml:space="preserve"> | |
| <value>打开链接</value> | |
| </data> | |
| <data name="menu.paste" xml:space="preserve"> | |
| <value>粘贴</value> | |
| </data> | |
| <data name="menu.removehyperlink" xml:space="preserve"> | |
| <value>&Remove Hyperlink</value> | |
| </data> | |
| <data name="menu.rename" xml:space="preserve"> | |
| <value>Rename</value> | |
| </data> | |
| <data name="menu.unhide" xml:space="preserve"> | |
| <value>UnHide</value> | |
| </data> | |
| <data name="msg.copy.invalidsheetname" xml:space="preserve"> | |
| <value>the worksheet name is invalid.</value> | |
| </data> | |
| <data name="msg.copy.protectsheet" xml:space="preserve"> | |
| <value>The cell or chart you're trying to change is on a protected sheet.To make a change,unprotect the sheet.You might be requested to enter a password.</value> | |
| </data> | |
| <data name="msg.copy.unsupportrange" xml:space="preserve"> | |
| <value>That command cannot be used on multiple selections.</value> | |
| </data> | |
| <data name="msg.del.multipleselection" xml:space="preserve"> | |
| <value>That command cannot be used on multiple selections.</value> | |
| </data> | |
| <data name="msg.delsheet.nomoresheet" xml:space="preserve"> | |
| <value>A workbook must contain at least one visible sheet</value> | |
| </data> | |
| <data name="msg.duplicatename" xml:space="preserve"> | |
| <value>That name is already taken,Try a diffrent one</value> | |
| </data> | |
| <data name="msg.filternumber.invalid" xml:space="preserve"> | |
| <value>Please enter correct number for filter</value> | |
| </data> | |
| <data name="msg.hyperlink.invalidaddress" xml:space="preserve"> | |
| <value>The address is not valid.</value> | |
| </data> | |
| <data name="msg.invalidpassword" xml:space="preserve"> | |
| <value>Invalid passowrd,the password can not be empty string.</value> | |
| </data> | |
| <data name="msg.invalidpassword.writeprotect" xml:space="preserve"> | |
| <value>The password for write protection you supplied is not correct.\nThe file is open as readonly.</value> | |
| </data> | |
| <data name="msg.invisiblesheet" xml:space="preserve"> | |
| <value>The sheet is invisible,you can not set it to active.</value> | |
| </data> | |
| <data name="msg.pagerows.limitation" xml:space="preserve"> | |
| <value>PageRows is out of range,we don't support rows more than 10000 per page.\nPlease hava a retry.</value> | |
| </data> | |
| <data name="msg.pages.limitation" xml:space="preserve"> | |
| <value>Page number is out of range,we don't support pages more than 5000.\nPlease try increase pagerows.</value> | |
| </data> | |
| <data name="msg.password.input" xml:space="preserve"> | |
| <value>Please input password!</value> | |
| </data> | |
| <data name="msg.password.invalid" xml:space="preserve"> | |
| <value>The password for write protection you supplied is not correct.</value> | |
| </data> | |
| <data name="msg.paste.notsamerange" xml:space="preserve"> | |
| <value>The information cannot be pasted because the Copy area and the paste area are not the same size and shape.</value> | |
| </data> | |
| <data name="msg.paste.protectsheet" xml:space="preserve"> | |
| <value>The cell or chart you're trying to change is on a protected sheet.To make a change,unprotect the sheet.You might be requested to enter a password</value> | |
| </data> | |
| <data name="pivot.allname" xml:space="preserve"> | |
| <value>(All)</value> | |
| </data> | |
| <data name="pivot.columnlabels" xml:space="preserve"> | |
| <value>Column Labels</value> | |
| </data> | |
| <data name="pivot.datafieldheader" xml:space="preserve"> | |
| <value>Data</value> | |
| </data> | |
| <data name="pivot.emptydataname" xml:space="preserve"> | |
| <value>(blank)</value> | |
| </data> | |
| <data name="pivot.grandtotalname" xml:space="preserve"> | |
| <value>Grand Total</value> | |
| </data> | |
| <data name="pivot.multipleitemsname" xml:space="preserve"> | |
| <value>(Multiple Items)</value> | |
| </data> | |
| <data name="pivot.protectionname" xml:space="preserve"> | |
| <value>Values</value> | |
| </data> | |
| <data name="pivot.rowlabels" xml:space="preserve"> | |
| <value>Row Labels</value> | |
| </data> | |
| <data name="pivot.subtotalname" xml:space="preserve"> | |
| <value>Total</value> | |
| </data> | |
| <data name="pivot.subtotaltype.average" xml:space="preserve"> | |
| <value>Average</value> | |
| </data> | |
| <data name="pivot.subtotaltype.count" xml:space="preserve"> | |
| <value>Count</value> | |
| </data> | |
| <data name="pivot.subtotaltype.countnums" xml:space="preserve"> | |
| <value>Count</value> | |
| </data> | |
| <data name="pivot.subtotaltype.max" xml:space="preserve"> | |
| <value>Max</value> | |
| </data> | |
| <data name="pivot.subtotaltype.min" xml:space="preserve"> | |
| <value>Min</value> | |
| </data> | |
| <data name="pivot.subtotaltype.product" xml:space="preserve"> | |
| <value>Product</value> | |
| </data> | |
| <data name="pivot.subtotaltype.stdev" xml:space="preserve"> | |
| <value>StdDev</value> | |
| </data> | |
| <data name="pivot.subtotaltype.stdevp" xml:space="preserve"> | |
| <value>StdDevp</value> | |
| </data> | |
| <data name="pivot.subtotaltype.sum" xml:space="preserve"> | |
| <value>Sum</value> | |
| </data> | |
| <data name="pivot.subtotaltype.var" xml:space="preserve"> | |
| <value>Var</value> | |
| </data> | |
| <data name="pivot.subtotaltype.varp" xml:space="preserve"> | |
| <value>Varp</value> | |
| </data> | |
| <data name="pivot.totalname" xml:space="preserve"> | |
| <value>Total</value> | |
| </data> | |
| </root> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| /* | |
| * Indicates whether to copy/paste based on clipboard, so that it can copy/paste with MS-EXCEL. | |
| * It will only copy/paste cell value and will not copy any other setting of the cell like format, border style and so on. | |
| * The default value is false. | |
| */ | |
| gridDesktop1.EnableClipboardCopyPaste = true; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Adding namespace to the top of code | |
| using System.Data.OleDb; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Adding new row to the worksheet | |
| gridDesktop1.GetActiveWorksheet().AddRow(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Iterating through each column of the worksheet | |
| for (int i = 0; i < sheet.ColumnsCount; i++) | |
| { | |
| // Getting the style object of each column | |
| Style style = sheet.Columns[i].GetStyle(); | |
| // Setting the color of each column to Yellow | |
| style.Color = Color.Yellow; | |
| // Setting the Horizontal Alignment of each column to Centered | |
| style.HAlignment = HorizontalAlignmentType.Centred; | |
| // Setting the style of column to the updated one | |
| sheet.Columns[i].SetStyle(style); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Binding the Worksheet to Products table by calling its DataBind method | |
| sheet.DataBind(ds.Tables["Products"], ""); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Customizing the widths of columns of the worksheet | |
| sheet.Columns[0].Width = 70; | |
| sheet.Columns[1].Width = 120; | |
| sheet.Columns[2].Width = 80; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Declaring global variable | |
| OleDbDataAdapter adapter; | |
| OleDbCommandBuilder cb; | |
| DataSet ds; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Getting the index of the focused row | |
| int focusedRowIndex = gridDesktop1.GetActiveWorksheet().GetFocusedCell().Row; | |
| // Removing the focused row fro the worksheet | |
| gridDesktop1.GetActiveWorksheet().RemoveRow(focusedRowIndex); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| private void DataBindingFeatures_Load(object sender, EventArgs e) | |
| { | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Creating Select query to fetch data from database | |
| string query = "SELECT * FROM Products ORDER BY ProductID"; | |
| // Creating connection string to connect with database | |
| string conStr = @"Provider=microsoft.jet.oledb.4.0;Data Source=" + dataDir + "dbDatabase.mdb"; | |
| // Creating OleDbDataAdapter object that will be responsible to open/close connections with database, fetch data and fill DataSet with data | |
| adapter = new OleDbDataAdapter(query, conStr); | |
| // Setting MissingSchemaAction to AddWithKey for getting necesssary primary key information of the tables | |
| adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; | |
| /* | |
| * Creating OleDbCommandBuilder object to create insert/delete SQL commmands | |
| * automatically that are used by OleDbDatAdapter object for updating | |
| * changes to the database | |
| */ | |
| cb = new OleDbCommandBuilder(adapter); | |
| // Creating DataSet object | |
| ds = new DataSet(); | |
| // Filling DataSet with data fetched by OleDbDataAdapter object | |
| adapter.Fill(ds, "Products"); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Updating the database according to worksheet data source | |
| adapter.Update((DataTable)sheet.DataSource); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Iterating through all columns of the Products table in DataSet | |
| for (int i = 0; i < ds.Tables["Products"].Columns.Count; i++) | |
| { | |
| // Setting the column header of each column to the column caption of Products table | |
| sheet.Columns[i].Header = ds.Tables["Products"].Columns[i].Caption; | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Accessing the cell using its name | |
| GridCell cell = sheet.Cells["A1"]; | |
| // Setting the value of "A1" cell | |
| cell.SetCellValue(DateTime.Now); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Accessing the cell using its name | |
| GridCell cell = sheet.Cells["A1"]; | |
| // Accessing & modifying the value of "A1" cell | |
| cell.Value = DateTime.Now; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Accessing a cell using its row and column indices | |
| GridCell cell = sheet.Cells[1, 1]; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Accessing a cell using its name | |
| GridCell cell = sheet.Cells["A1"]; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Accessing a cell that is currently in focus | |
| GridCell cell = sheet.GetFocusedCell(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Make sure sheet has been protected | |
| sheet.Protected = true; | |
| // Choose a cell range | |
| CellRange range = sheet.CreateRange("A1", "B1"); | |
| // Set protected range area on Worksheet | |
| sheet.SetProtected(range, true); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Adding numeric values to "B2" & "B3" cells | |
| sheet.Cells["B2"].SetCellValue(3); | |
| sheet.Cells["B3"].SetCellValue(4); | |
| // Adding a formula to "B4" cell multiplying the values of "B2" & "B3" cells | |
| sheet.Cells["B4"].SetCellValue("=B2 * B3"); | |
| // Running all formulas in the Grid | |
| gridDesktop1.RunAllFormulas(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Accessing "A1" cell in the worksheet | |
| GridCell cell = sheet.Cells["A1"]; | |
| // Adding a value to "A1" cell | |
| cell.Value = "Hello"; | |
| // Getting the Style object for the cell | |
| Style style = cell.GetStyle(); | |
| // Setting Style properties like border, alignment etc. | |
| style.SetBorderLine(BorderType.Right, BorderLineType.Thick); | |
| style.SetBorderColor(BorderType.Right, Color.Blue); | |
| style.HAlignment = HorizontalAlignmentType.Centred; | |
| style.Color = Color.Yellow; | |
| style.CellLocked = true; | |
| style.VAlignment = VerticalAlignmentType.Top; | |
| // Setting the style of the cell with the customized Style object | |
| cell.SetStyle(style); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Aspose.Cells.GridDesktop.Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Creating a standard Font object that will be applied on cells | |
| System.Drawing.Font font = new System.Drawing.Font("MS Serif", 9f, FontStyle.Bold); | |
| // Accessing and adding values to cells | |
| Aspose.Cells.GridDesktop.GridCell cell = sheet.Cells["B2"]; | |
| cell.Value = "General"; | |
| cell.SetFont(font); | |
| cell = sheet.Cells["C2"]; | |
| cell.Value = 1000; | |
| cell = sheet.Cells["D2"]; | |
| cell.Value = "Text"; | |
| cell = sheet.Cells["B4"]; | |
| cell.Value = "Number"; | |
| cell.SetFont(font); | |
| //Accessing the Style object of "C4" cell and setting its number format to index No.2 | |
| cell = sheet.Cells["C4"]; | |
| cell.Value = 20.00; | |
| Aspose.Cells.GridDesktop.Style style = cell.GetStyle(); | |
| // For applying "0.00" format | |
| style.NumberFormat = 2; | |
| cell.SetStyle(style); | |
| // Accessing the Style object of "D4" cell and setting its number format to index No.3 | |
| cell = sheet.Cells["D4"]; | |
| cell.Value = -2000.00; | |
| style = cell.GetStyle(); | |
| // For "#,##0" format | |
| style.NumberFormat = 3; | |
| cell.SetStyle(style); | |
| // Accessing a cell and setting its value & font | |
| cell = sheet.Cells["B6"]; | |
| cell.Value = "Currency"; | |
| cell.SetFont(font); | |
| // Accessing the Style object of "C6" cell and setting its number format to index No.6 | |
| cell = sheet.Cells["C6"]; | |
| cell.Value = -120.00; | |
| style = cell.GetStyle(); | |
| // For Applying "\"$\"#,##0_);[Red](\"$\"#,##0)" expression | |
| style.NumberFormat = 6; | |
| cell.SetStyle(style); | |
| // Accessing the Style object of "D6" cell and setting its number format to index No.41 | |
| cell = sheet.Cells["D6"]; | |
| cell.Value = 2400; | |
| style = cell.GetStyle(); | |
| // For applying "_(\"$\"* #,##0_);_(\"$\"* (#,##0);_(\"$\"* \"-\"_);_(@_)" expression | |
| style.NumberFormat = 41; | |
| cell.SetStyle(style); | |
| // Accessing a cell and setting its value & font | |
| cell = sheet.Cells["B8"]; | |
| cell.Value = "Percent"; | |
| cell.SetFont(font); | |
| // Accessing the Style object of "C8" cell and setting its number format to index No.9 | |
| cell = sheet.Cells["C8"]; | |
| cell.Value = 0.32; | |
| style = cell.GetStyle(); | |
| style.NumberFormat = 9; | |
| cell.SetStyle(style); | |
| // Accessing the Style object of "D8" cell and setting its number format to index No.10 | |
| cell = sheet.Cells["D8"]; | |
| cell.Value = 0.64; | |
| style = cell.GetStyle(); | |
| // For applying "0.00%" format | |
| style.NumberFormat = 10; | |
| cell.SetStyle(style); | |
| // Accessing a cell and setting its value & font | |
| cell = sheet.Cells["B10"]; | |
| cell.Value = "Scientific"; | |
| cell.SetFont(font); | |
| // Accessing the Style object of "C10" cell and setting its number format to index No.11 | |
| cell = sheet.Cells["C10"]; | |
| cell.Value = 0.51; | |
| style = cell.GetStyle(); | |
| // For applying "0.00E+00" format | |
| style.NumberFormat = 11; | |
| cell.SetStyle(style); | |
| // Accessing the Style object of "D10" cell and setting its number format to index No.48 | |
| cell = sheet.Cells["D10"]; | |
| cell.Value = 32000; | |
| style = cell.GetStyle(); | |
| style.NumberFormat = 48; | |
| cell.SetStyle(style); | |
| // Accessing a cell and setting its value & font | |
| cell = sheet.Cells["B12"]; | |
| cell.Value = "DateTime"; | |
| cell.SetFont(font); | |
| // Accessing the Style object of "C12" cell and setting a custom number format for it | |
| cell = sheet.Cells["C12"]; | |
| cell.Value = DateTime.Now; | |
| style = cell.GetStyle(); | |
| style.Custom = "yyyy-MM-dd"; | |
| cell.SetStyle(style); | |
| // Accessing the Style object of "D12" cell and setting its number format to Index No.15 | |
| cell = sheet.Cells["D12"]; | |
| sheet.Columns[cell.Column].Width = 100; | |
| cell.Value = DateTime.Now; | |
| style = cell.GetStyle(); | |
| // For "d-mmm-yy" | |
| style.NumberFormat = 15; | |
| cell.SetStyle(style); | |
| // Accessing the Style object of "C13" cell and setting a custom number format for it | |
| cell = sheet.Cells["C13"]; | |
| cell.Value = DateTime.Now; | |
| style = cell.GetStyle(); | |
| style.Custom = "hh:mm:ss"; | |
| cell.SetStyle(style); | |
| // Accessing the Style object of "D13" cell and setting its number format to index No.18 | |
| cell = sheet.Cells["D13"]; | |
| cell.Value = DateTime.Now; | |
| style = cell.GetStyle(); | |
| // For applying "h:mm AM/PM" format | |
| style.NumberFormat = 18; | |
| cell.SetStyle(style); | |
| // Accessing the Style object of "C14" cell and setting a custom number format for it | |
| cell = sheet.Cells["C14"]; | |
| sheet.Columns[cell.Column].Width = 160; | |
| cell.Value = DateTime.Now; | |
| style = cell.GetStyle(); | |
| style.Custom = "yyyy-MM-dd hh:mm:ss"; | |
| cell.SetStyle(style); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Aspose.Cells.GridDesktop.Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Accessing "B2" cell and setting its value | |
| Aspose.Cells.GridDesktop.GridCell cell = sheet.Cells["B2"]; | |
| cell.Value = "None"; | |
| // Accessing "D4" cell and setting its value & column width | |
| cell = sheet.Cells["D4"]; | |
| cell.Value = "out line Borders"; | |
| sheet.Columns[cell.Column].Width = 120; | |
| // Accessing the Style object of "D4" cell and drawing thin red borders around it | |
| Aspose.Cells.GridDesktop.Style style = cell.GetStyle(); | |
| style.SetBorderLine(BorderType.Left, BorderLineType.Thin); | |
| style.SetBorderColor(BorderType.Left, System.Drawing.Color.Red); | |
| style.SetBorderLine(BorderType.Right, BorderLineType.Thin); | |
| style.SetBorderColor(BorderType.Right, System.Drawing.Color.Red); | |
| style.SetBorderLine(BorderType.Top, BorderLineType.Thin); | |
| style.SetBorderColor(BorderType.Top, System.Drawing.Color.Red); | |
| style.SetBorderLine(BorderType.Bottom, BorderLineType.Thin); | |
| style.SetBorderColor(BorderType.Bottom, System.Drawing.Color.Red); | |
| cell.SetStyle(style); | |
| // Accessing "B6" cell and setting its value, row height & column width | |
| cell = sheet.Cells["B6"]; | |
| cell.Value = "Border with\ndifferent colors"; | |
| sheet.Rows[cell.Row].Height = 40; | |
| sheet.Columns[cell.Column].Width = 110; | |
| // Accessing the Style object of "B6" cell and drawing thin borders of different colors around it | |
| style = cell.GetStyle(); | |
| style.SetBorderLine(BorderType.Left, BorderLineType.Thin); | |
| style.SetBorderColor(BorderType.Left, System.Drawing.Color.Red); | |
| style.SetBorderLine(BorderType.Right, BorderLineType.Thin); | |
| style.SetBorderColor(BorderType.Right, System.Drawing.Color.Green); | |
| style.SetBorderLine(BorderType.Top, BorderLineType.Thin); | |
| style.SetBorderColor(BorderType.Top, System.Drawing.Color.Yellow); | |
| style.SetBorderLine(BorderType.Bottom, BorderLineType.Thin); | |
| style.SetBorderColor(BorderType.Bottom, System.Drawing.Color.Blue); | |
| cell.SetStyle(style); | |
| // Accessing "D7" cell and setting its value, row height & column width | |
| cell = sheet.Cells["D7"]; | |
| cell.Value = "Border with\ndifferent styles"; | |
| sheet.Rows[cell.Row].Height = 40; | |
| sheet.Columns[cell.Column].Width = 110; | |
| // Accessing the Style object of "D7" cell and drawing different borders of different colors around it | |
| style = cell.GetStyle(); | |
| style.SetBorderLine(BorderType.Left, BorderLineType.Thin); | |
| style.SetBorderColor(BorderType.Left, System.Drawing.Color.Red); | |
| style.SetBorderLine(BorderType.Right, BorderLineType.Medium); | |
| style.SetBorderColor(BorderType.Right, System.Drawing.Color.Red); | |
| style.SetBorderLine(BorderType.Top, BorderLineType.Dashed); | |
| style.SetBorderColor(BorderType.Top, System.Drawing.Color.Yellow); | |
| style.SetBorderLine(BorderType.Bottom, BorderLineType.Dotted); | |
| style.SetBorderColor(BorderType.Bottom, System.Drawing.Color.Black); | |
| cell.SetStyle(style); | |
| // Accessing "B8" cell and drawing a single red border to its bottom side | |
| cell = sheet.Cells["B8"]; | |
| cell.Value = "Only one border"; | |
| style = cell.GetStyle(); | |
| style.SetBorderLine(BorderType.Bottom, BorderLineType.MediumDashDotted); | |
| style.SetBorderColor(BorderType.Bottom, System.Drawing.Color.Red); | |
| cell.SetStyle(style); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Accessing a cell using its name | |
| GridCell cell = sheet.Cells["A1"]; | |
| // Creating a customized Font object | |
| Font font = new Font("Arial", 10, FontStyle.Bold); | |
| // Setting the font of the cell to the customized Font object | |
| cell.SetFont(font); | |
| // Setting the font color of the cell to Blue | |
| cell.SetFontColor(Color.Blue); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Enable GridDesktop's auto-filter. | |
| gridDesktop1.Worksheets[0].RowFilter.EnableAutoFilter = true; | |
| // Set the header row. | |
| gridDesktop1.Worksheets[0].RowFilter.HeaderRow = 0; | |
| // Set the starting row. | |
| gridDesktop1.Worksheets[0].RowFilter.StartRow = 1; | |
| // Set the ending row. | |
| gridDesktop1.Worksheets[0].RowFilter.EndRow = 101; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Set the starting row. | |
| gridDesktop1.Worksheets[0].RowFilter.StartRow = 1; | |
| // Set the ending row. | |
| gridDesktop1.Worksheets[0].RowFilter.EndRow = 101; | |
| // Get the RowFilter object for the first worksheet. | |
| RowFilterSettings rowFilter = gridDesktop1.Worksheets[0].RowFilter; | |
| // Filter Rows. | |
| rowFilter.FilterRows(0, "Customer 1"); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Setting sample values | |
| GridCell cell = sheet.Cells["b7"]; | |
| cell.SetCellValue("1"); | |
| cell = sheet.Cells["c7"]; | |
| cell.SetCellValue("2"); | |
| cell = sheet.Cells["d7"]; | |
| cell.SetCellValue("3"); | |
| cell = sheet.Cells["e7"]; | |
| cell.SetCellValue("4"); | |
| // Creating a CellRange object starting from "B7" to "E7" | |
| CellRange range = new CellRange(6, 1, 6, 4); | |
| // Accessing and setting Style attributes | |
| Style style = new Style(this.gridDesktop1); | |
| style.Color = Color.Yellow; | |
| // Applying Style object on the range of cells | |
| sheet.SetStyle(range, style); | |
| // Creating a customized Font object | |
| Font font = new Font("Courier New", 12f); | |
| // Setting the font of range of cells to the customized Font object | |
| sheet.SetFont(range, font); | |
| // Setting the font color of range of cells to Red | |
| sheet.SetFontColor(range, Color.Red); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Creating a CellRange object starting from "B4" to "C6" | |
| CellRange range = new CellRange("B4", "C6"); | |
| // Merging a range of cells | |
| sheet.Merge(range); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Accessing the merged cell that is currently in focus | |
| GridCell cell = sheet.GetFocusedCell(); | |
| // Unmerging a cell using its location | |
| sheet.Unmerge(cell.Location); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Create the UndoManager object | |
| UndoManager um = gridDesktop1.UndoManager; | |
| // Perform Redo operation | |
| um.Redo(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Enable the Undo operation | |
| gridDesktop1.EnableUndo = true; | |
| // Create the UndoManager object | |
| UndoManager um = gridDesktop1.UndoManager; | |
| // Perform Undo operation | |
| um.Undo(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Ending format painter to stop painting | |
| gridDesktop1.EndFormatPainter(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Starting format painter to keep painting forever | |
| gridDesktop1.StartFormatPainter(true); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Starting format painter to paint once | |
| gridDesktop1.StartFormatPainter(false); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Clear the Worsheets first | |
| _grid.Clear(); | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Specifying the path of Excel file using ImportExcelFile method of the control | |
| _grid.ImportExcelFile(dataDir + "book1.xlsx"); | |
| // Apply a formula to a cell that refers to a named range "Rang1" | |
| _grid.Worksheets[0].Cells["G6"].SetCellValue("=SUM(Range1)"); | |
| // Add a new named range "MyRange" with based area A2:B5 | |
| int index = _grid.Names.Add("MyRange", "Sheet1!A2:B5"); | |
| // Apply a formula to G7 cell | |
| _grid.Worksheets[0].Cells["G7"].SetCellValue("=SUM(MyRange)"); | |
| // Calculate the results of the formulas | |
| _grid.RunAllFormulas(); | |
| // Save the Excel file | |
| _grid.ExportExcelFile(dataDir + @"ouputBook1_out.xlsx"); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| private void gridDesktop1_CellClick(object sender, Aspose.Cells.GridDesktop.CellEventArgs e) | |
| { | |
| MessageBox.Show("Cell is clicked"); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // | |
| // gridDesktop1 | |
| // | |
| this.gridDesktop1.ActiveSheetIndex = 0; | |
| this.gridDesktop1.ActiveSheetNameFont = null; | |
| this.gridDesktop1.CommentDisplayingFont = new System.Drawing.Font("Arial", 9F); | |
| this.gridDesktop1.Dock = System.Windows.Forms.DockStyle.Fill; | |
| this.gridDesktop1.IsHorizontalScrollBarVisible = true; | |
| this.gridDesktop1.IsVerticalScrollBarVisible = true; | |
| this.gridDesktop1.Location = new System.Drawing.Point(0, 0); | |
| this.gridDesktop1.Name = "gridDesktop1"; | |
| this.gridDesktop1.SheetNameFont = new System.Drawing.Font("Verdana", 8F); | |
| this.gridDesktop1.SheetTabWidth = 400; | |
| this.gridDesktop1.Size = new System.Drawing.Size(657, 452); | |
| this.gridDesktop1.TabIndex = 0; | |
| this.gridDesktop1.CellClick += new Aspose.Cells.GridDesktop.CellEventHandler(this.gridDesktop1_CellClick); | |
| // | |
| // GridDesktopEvents | |
| // |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Specifying the path of Excel file using ImportExcelFile method of the control | |
| gridDesktop1.ImportExcelFile(dataDir + "SampleCSV1.csv"); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Specifying the path of Excel file using ImportExcelFile method of the control | |
| gridDesktop1.ImportExcelFile(dataDir + "Sample.xlsx"); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Opening an Excel file as a stream | |
| FileStream fs = File.OpenRead(dataDir + "Sample.xlsx"); | |
| // Loading the Excel file contents into the control from a stream | |
| gridDesktop1.ImportExcelFile(fs); | |
| // Closing stream | |
| fs.Close(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Saving Grid contents to an Excel file | |
| gridDesktop1.ExportExcelFile(dataDir + "book1_out.xls"); | |
| // Saving Grid contents to MS Excel 2007 Xlsx file format | |
| gridDesktop1.ExportExcelFile(Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType) + "book1_out.xlsx", FileFormatType.Excel2007Xlsx); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Opening an Excel file as a stream | |
| FileStream fs = File.Open(dataDir + "book1_out.xls", FileMode.Open, FileAccess.ReadWrite); | |
| // Saving Grid contents of the control to a stream | |
| gridDesktop1.ExportExcelFile(fs); | |
| // Closing stream | |
| fs.Close(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Adding checkbox to a specific column of the Worksheet | |
| sheet.Columns[2].AddCheckBox(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Creating an array of items or values that will be added to combobox | |
| string[] items = new string[3]; | |
| items[0] = "Aspose"; | |
| items[1] = "Aspose.Grid"; | |
| items[2] = "Aspose.Grid.Desktop"; | |
| // Adding combobox (containing items) to a specific column of the Worksheet | |
| sheet.Columns[2].AddComboBox(items); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Adding column to the worksheet | |
| sheet.AddColumn(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Adding row to the worksheet | |
| sheet.AddRow(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Accessing the first column of the worksheet | |
| Aspose.Cells.GridDesktop.Data.GridColumn column = sheet.Columns[0]; | |
| // Adding sample value to sheet cell | |
| GridCell cell = sheet.Cells["a1"]; | |
| cell.SetCellValue("Aspose"); | |
| // Getting the Style object for the column | |
| Style style = column.GetStyle(); | |
| // Setting Style properties i.e. border, alignment color etc. | |
| style.SetBorderLine(BorderType.Right, BorderLineType.Thick); | |
| style.SetBorderColor(BorderType.Right, Color.Blue); | |
| style.HAlignment = HorizontalAlignmentType.Centred; | |
| // Setting the style of the column with the customized Style object | |
| column.SetStyle(style); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Setting the number of frozen columns to 2 | |
| sheet.FrozenCols = 2; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Setting the number of frozen rows to 2 | |
| sheet.FrozenRows = 2; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Setting the number of frozen columns to 0 for unfreezing columns | |
| sheet.FrozenCols = 0; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Setting the number of frozen rows to 0 for unfreezing rows | |
| sheet.FrozenRows = 0; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Accessing cell control in the column and typecasting it to CheckBox | |
| Aspose.Cells.GridDesktop.CheckBox cb = (Aspose.Cells.GridDesktop.CheckBox)sheet.Columns[2].CellControl; | |
| if (cb != null) | |
| { | |
| // Modifying the Checked property of CheckBox | |
| cb.Checked = true; | |
| } | |
| else | |
| { | |
| MessageBox.Show("Please add control before accessing it."); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Removing cell control from the column | |
| sheet.Columns[2].RemoveCellControl(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Removing the first column of the worksheet | |
| sheet.RemoveColumn(0); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Removing the first row of the worksheet | |
| sheet.RemoveRow(0); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Adding sample value to sheet cell | |
| GridCell cell = sheet.Cells["a1"]; | |
| cell.SetCellValue("Welcome to Aspose!"); | |
| // Accessing the first column of the worksheet | |
| Aspose.Cells.GridDesktop.Data.GridColumn column = sheet.Columns[0]; | |
| // Setting the width of the column | |
| column.Width = 150; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Adding sample value to sheet cells | |
| GridCell cell = sheet.Cells["b2"]; | |
| cell.SetCellValue("1"); | |
| cell = sheet.Cells["c2"]; | |
| cell.SetCellValue("2"); | |
| cell = sheet.Cells["d2"]; | |
| cell.SetCellValue("3"); | |
| cell = sheet.Cells["e2"]; | |
| cell.SetCellValue("4"); | |
| // Accessing the first row of the worksheet | |
| Aspose.Cells.GridDesktop.Data.GridRow row = sheet.Rows[1]; | |
| // Setting the height of the row | |
| row.Height = 100; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Adding Is Required Validation to a column | |
| sheet.Columns[2].AddValidation(true, ""); | |
| // Adding simple Regular Expression Validation to a column | |
| sheet.Columns[4].AddValidation(true, @"\d+"); | |
| // Adding complex Regular Expression Validation to a column | |
| sheet.Columns[6].AddValidation(true, @"\d{4}-\d{2}-\d{2}"); | |
| // Adding Custom Validation to a column | |
| sheet.Columns[8].AddValidation(new CustomValidation()); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accesing an active worksheet using its index | |
| Worksheet sheet = gridDesktop1.Worksheets[gridDesktop1.ActiveSheetIndex]; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accesing an active worksheet directly | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accesing a worksheet using its index | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accesing a worksheet using its name | |
| Worksheet sheet = gridDesktop1.Worksheets["Sheet2"]; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Accessing the location of the cell that is currently in focus | |
| CellLocation cl = sheet.GetFocusedCellLocation(); | |
| // Adding checkbox to the Controls collection of the Worksheet | |
| sheet.Controls.AddCheckBox(cl.Row, cl.Column, true); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Accessing the location of the cell that is currently in focus | |
| CellLocation cl = sheet.GetFocusedCellLocation(); | |
| // Creating an array of items or values that will be added to combobox | |
| string[] items = new string[3]; | |
| items[0] = "Aspose"; | |
| items[1] = "Aspose.Grid"; | |
| items[2] = "Aspose.Grid.Desktop"; | |
| // Adding combobox to the Controls collection of the Worksheet | |
| sheet.Controls.AddComboBox(cl.Row, cl.Column, items); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Implenting CellCheckedChanged event handler | |
| private void gridDesktop1_CellCheckedChanged(object sender, CellControlEventArgs e) | |
| { | |
| // Getting the reference of the CheckBox control whose event is triggered | |
| Aspose.Cells.GridDesktop.CheckBox check = (Aspose.Cells.GridDesktop.CheckBox)gridDesktop1.GetActiveWorksheet().Controls[e.Row, e.Column]; | |
| // Displaying the message when the Checked state of CheckBox is changed | |
| MessageBox.Show("Current state of CheckBox is " + check.Checked); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Implenting CellSelectedIndexChanged event handler | |
| private void gridDesktop1_CellSelectedIndexChanged(object sender, CellComboBoxEventArgs e) | |
| { | |
| // Getting the reference of the ComboBox control whose event is triggered | |
| Aspose.Cells.GridDesktop.ComboBox combo = | |
| (Aspose.Cells.GridDesktop.ComboBox)gridDesktop1.GetActiveWorksheet().Controls[e.Row, e.Column]; | |
| // Displaying the message when the Selected Index of ComboBox is changed | |
| MessageBox.Show(combo.Items[combo.SelectedIndex].ToString()); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Set the image. | |
| Image image = Image.FromFile(dataDir + @"AsposeLogo.jpg"); | |
| button.Image = image; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Adding a worksheet to the Grid | |
| int i = gridDesktop1.Worksheets.Add(); | |
| Worksheet sheet = gridDesktop1.Worksheets[i]; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Adding a worksheet to the Grid with a specific name | |
| Worksheet sheet1 = gridDesktop1.Worksheets.Add("AddWorksheetWithName"); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Inserting a worksheet to Grid at first position of the worksheets collection | |
| gridDesktop1.Worksheets.Insert(0); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Hiding the vertical scroll bar | |
| gridDesktop1.IsVerticalScrollBarVisible = false; | |
| // Hiding the horizontal scroll bar | |
| gridDesktop1.IsHorizontalScrollBarVisible = false; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Displaying the vertical scroll bar | |
| gridDesktop1.IsVerticalScrollBarVisible = true; | |
| // Displaying the horizontal scroll bar | |
| gridDesktop1.IsHorizontalScrollBarVisible = true; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the reference of the worksheet that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| //Getting the total number of rows and columns inside the worksheet | |
| int totalRows = sheet.RowsCount; | |
| int totalCols = sheet.ColumnsCount; | |
| // Exporting the data of the active worksheet to a new DataTable object | |
| DataTable table = sheet.ExportDataTable(0, 0, totalRows, totalCols, false, true); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Creating a new DataTable object | |
| DataTable dataTable = new DataTable(); | |
| // Adding specific columns to the DataTable object | |
| dataTable.Columns.Add("ProductName", System.Type.GetType("System.String")); | |
| dataTable.Columns.Add("CategoryName", System.Type.GetType("System.String")); | |
| dataTable.Columns.Add("QuantityPerUnit", System.Type.GetType("System.String")); | |
| dataTable.Columns.Add("UnitsInStock", System.Type.GetType("System.Int32")); | |
| // Exporting the data of the first worksheet of the Grid to the specific DataTable object | |
| dataTable = gridDesktop1.Worksheets[0].ExportDataTable(dataTable, 0, 0, 69, 4, true); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| OleDbDataAdapter adapter; | |
| DataTable dt = new DataTable(); | |
| // Creating connection string to connect with database | |
| string conStr = @"Provider=microsoft.jet.oledb.4.0;Data Source=" + dataDir + "dbDatabase.mdb"; | |
| // Creating Select query to fetch data from database | |
| string query = "SELECT * FROM Products ORDER BY ProductID"; | |
| adapter = new OleDbDataAdapter(query, conStr); | |
| // Filling DataTable using an already created OleDbDataAdapter object | |
| adapter.Fill(dt); | |
| // Accessing the reference of a worksheet | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Importing data from DataTable to the worksheet. 0,0 specifies to start importing data from the cell with first row (0 index) and first column (0 index) | |
| sheet.ImportDataTable(dt, false, 0, 0); | |
| // Iterating through the number of columns contained in the DataTable | |
| for (int i = 0; i < dt.Columns.Count; i++) | |
| { | |
| // Setting the column headers of the worksheet according to column names of the DataTable | |
| sheet.Columns[i].Header = dt.Columns[i].Caption; | |
| } | |
| // Setting the widths of the columns of the worksheet | |
| sheet.Columns[0].Width = 240; | |
| sheet.Columns[1].Width = 160; | |
| sheet.Columns[2].Width = 160; | |
| sheet.Columns[3].Width = 100; | |
| // Displaying the contents of the worksheet by making it active | |
| gridDesktop1.ActiveSheetIndex = 0; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Getting the location of the cell that is currently in focus | |
| CellLocation cl = sheet.GetFocusedCellLocation(); | |
| // Accessing cell control and typecasting it to CheckBox | |
| Aspose.Cells.GridDesktop.CheckBox cb = (Aspose.Cells.GridDesktop.CheckBox)sheet.Controls[cl.Row, cl.Column]; | |
| if (cb != null) | |
| { | |
| // Modifying the Checked property of CheckBox | |
| cb.Checked = true; | |
| } | |
| else | |
| { | |
| MessageBox.Show("Please add control before accessing it."); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing the worksheet of the Grid that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Getting the location of the cell that is currently in focus | |
| CellLocation cl = sheet.GetFocusedCellLocation(); | |
| // Removing the cell control by specifying the location of cell containing it | |
| sheet.Controls.Remove(cl.Row, cl.Column); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Accessing a comment added to "c3" cell (specified using its row & column number) | |
| Aspose.Cells.GridDesktop.Data.GridComment comment1 = sheet.Comments[3, 1]; | |
| if (comment1 != null) | |
| { | |
| // Modifying the text of comment | |
| comment1.Text = "The 1st comment."; | |
| MessageBox.Show("Comment has been modified"); | |
| } | |
| else | |
| { | |
| MessageBox.Show("Please add comment before accessing it."); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Adding comment to "b2" cell | |
| sheet.Comments.Add("b2", "Please write your name."); | |
| // Adding another comment to "b4" cell using its row & column number | |
| sheet.Comments.Add(3, 1, "Please write your email."); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| if (sheet.Comments[3, 1] != null) | |
| { | |
| // Removing comment from "c3" cell | |
| sheet.Comments.Remove(3, 1); | |
| MessageBox.Show("Comment has been removed"); | |
| } | |
| else | |
| { | |
| MessageBox.Show("Please add comment before removing it."); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Accessing a hyperlink added to "c3,b2" cells (specified using its row & column number) | |
| Aspose.Cells.GridDesktop.Data.GridHyperlink hyperlink1 = sheet.Hyperlinks[2, 2]; | |
| Aspose.Cells.GridDesktop.Data.GridHyperlink hyperlink2 = sheet.Hyperlinks[1, 1]; | |
| if (hyperlink1 != null && hyperlink2 != null) | |
| { | |
| // Modifying the Url of the hyperlink | |
| hyperlink1.Url = "www.aspose.com"; | |
| hyperlink2.Url = "www.aspose.com"; | |
| MessageBox.Show("Hyperlinks are accessed and URL's are: \n" + hyperlink1.Url + "\n" + hyperlink2.Url); | |
| } | |
| else | |
| { | |
| MessageBox.Show("No hyperlinks are found in sheet. Add hyperlinks first."); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Accessing cell of the worksheet | |
| GridCell cell = sheet.Cells["b2"]; | |
| GridCell cell2 = sheet.Cells["c3"]; | |
| // Modifying the width of the column of the cell | |
| sheet.Columns[cell.Column].Width = 160; | |
| sheet.Columns[cell2.Column].Width = 160; | |
| // Adding a value to the cell | |
| cell.Value = "Aspose Home"; | |
| cell2.Value = "Aspose Home"; | |
| // Adding a hyperlink to the worksheet containing cell name and the hyperlink URL with which the cell will be linked | |
| sheet.Hyperlinks.Add("b2", "www.aspose.com"); | |
| sheet.Hyperlinks.Add("c3", "www.aspose.com"); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| if (sheet.Hyperlinks.Count > 0) | |
| { | |
| // Removing hyperlink from "c3" cell | |
| sheet.Hyperlinks.Remove(2, 2); | |
| MessageBox.Show("Hyperlink in C3 cell has been removed."); | |
| } | |
| else | |
| { | |
| MessageBox.Show("No hyperlinks are found in sheet to remove. Add hyperlinks first."); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Accessing a picture added to "c3" cell (specified using its row & column number) | |
| Aspose.Cells.GridDesktop.Data.GridPicture picture1 = sheet.Pictures[1]; | |
| // Modifying the image | |
| picture1.Image = Image.FromFile(dataDir + "Aspose.Grid.jpg"); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Adding picture to "b2" cell from file | |
| sheet.Pictures.Add("b2", dataDir + "AsposeGrid.jpg"); | |
| // Creating a stream contain picture | |
| FileStream fs = new FileStream(dataDir + "AsposeLogo.jpg", FileMode.Open); | |
| try | |
| { | |
| // Adding picture to "b3" cell from stream | |
| sheet.Pictures.Add(2, 1, fs); | |
| } | |
| catch (Exception ex) | |
| { | |
| MessageBox.Show(ex.Message); | |
| } | |
| finally | |
| { | |
| // Closing stream | |
| fs.Close(); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Removing picture from "c3" cell | |
| sheet.Pictures.Remove(2, 2); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Move the 2nd worksheet to 4th position. | |
| gridDesktop1.Worksheets.MoveTo(1, 3); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Import sample excel file in GridDesktop | |
| gridDesktop1.ImportExcelFile(dataDir + "ValidationTesting.xlsx"); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Removing a worksheet using its index | |
| gridDesktop1.Worksheets.Remove(0); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Removing a worksheet using its index | |
| gridDesktop1.Worksheets.RemoveAt("Sheet3"); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accesing an active worksheet directly | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Renaming a worksheet | |
| sheet.Name = "Renamed Sheet"; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing a worksheet that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Creating SortRange object | |
| SortRange sr = new SortRange(sheet, range.StartRow, | |
| range.StartColumn, range.EndRow - range.StartRow + 1, | |
| range.EndColumn - range.StartColumn + 1, | |
| SortOrientation.SortTopToBottom, true); | |
| // Sorting data in the specified column in ascending order | |
| sr.Sort(range.StartColumn, Aspose.Cells.GridDesktop.SortOrder.Ascending); | |
| // Redrawing cells of the Grid | |
| gridDesktop1.Invalidate(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Creating global variable of CellRange | |
| CellRange range; | |
| private void gridDesktop1_SelectedCellRangeChanged(object sender, Aspose.Cells.GridDesktop.CellRangeEventArgs e) | |
| { | |
| // Checking if the range of cells is not empty | |
| if ((e.CellRange.EndColumn - e.CellRange.StartColumn > 0) || | |
| (e.CellRange.EndRow - e.CellRange.StartRow > 0)) | |
| { | |
| // Assigning the updated CellRange to global variable | |
| range = e.CellRange; | |
| } | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing a worksheet that is currently active | |
| Worksheet sheet = gridDesktop1.GetActiveWorksheet(); | |
| // Creating SortRange object | |
| SortRange sr = new SortRange(sheet, range.StartRow, range.StartColumn, | |
| range.EndRow - range.StartRow + 1, | |
| range.EndColumn - range.StartColumn + 1, | |
| SortOrientation.SortTopToBottom, true); | |
| // Sorting data in the specified column in descending order | |
| sr.Sort(range.StartColumn, Aspose.Cells.GridDesktop.SortOrder.Descending); | |
| // Redrawing cells of the Grid | |
| gridDesktop1.Invalidate(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| if (sheet.Validations.Count > 0) | |
| { | |
| // Accessing the Validation object applied on "a8" cell | |
| Aspose.Cells.GridDesktop.Data.GridValidation validation = sheet.Validations[7, 0]; | |
| // Editing the attributes of Validation | |
| validation.IsRequired = true; | |
| validation.RegEx = ""; | |
| validation.CustomValidation = null; | |
| MessageBox.Show("Validation has been edited after accessing it."); | |
| } | |
| else | |
| { | |
| MessageBox.Show("No validations found to access."); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| // Adding values to specific cells of the worksheet | |
| sheet.Cells["a2"].Value = "Required"; | |
| sheet.Cells["a4"].Value = "100"; | |
| sheet.Cells["a6"].Value = "2006-07-21"; | |
| sheet.Cells["a8"].Value = "101.2"; | |
| // Adding Is Required Validation to a cell | |
| sheet.Validations.Add("a2", true, ""); | |
| // Adding simple Regular Expression Validation to a cell | |
| sheet.Validations.Add("a4", true, @"\d+"); | |
| // Adding complex Regular Expression Validation to a cell | |
| sheet.Validations.Add("a6", true, @"\d{4}-\d{2}-\d{2}"); | |
| // Adding Custom Validation to a cell | |
| sheet.Validations.Add("a8", new CustomValidation()); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Implementing ICustomValidation interface | |
| public class CustomValidation : Aspose.Cells.GridDesktop.ICustomValidation | |
| { | |
| // Implementing Validate method already defined in the interface | |
| public bool Validate(Worksheet worksheet, int row, int col, object value) | |
| { | |
| // Checking the cell's address | |
| if (row == 7 && col == 0) | |
| { | |
| //Checking the data type of cell's value | |
| double d = 0; | |
| try | |
| { | |
| d = (double)value; | |
| } | |
| catch | |
| { | |
| return false; | |
| } | |
| // Checking if the cell's value is greater than 100 | |
| if (d > 100) | |
| return true; | |
| } | |
| return false; | |
| } | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Accessing first worksheet of the Grid | |
| Worksheet sheet = gridDesktop1.Worksheets[0]; | |
| if (sheet.Validations.Count > 0) | |
| { | |
| // Removing the Validation object applied on "a6" cell | |
| sheet.Validations.RemoveAt(1); | |
| MessageBox.Show("Validation has been removed."); | |
| } | |
| else | |
| { | |
| MessageBox.Show("No validations found to remove."); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Importing the template Excel file to GridDesktop | |
| gridDesktop1.ImportExcelFile(dataDir + "EmployeeSales.xlsx"); | |
| // Set the default value of the TrackBar control | |
| trackBar1.Value = 100; | |
| // Set the custom label's text to the trackbar's value for display | |
| label1.Text = trackBar1.Value.ToString() + "%"; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // Set the Zoom factor of the active worksheet to the Trackbar's value | |
| gridDesktop1.Worksheets[gridDesktop1.GetActiveWorksheet().Index].Zoom = trackBar1.Value; | |
| // Show the percentage value of the specified Zoom | |
| label1.Text = trackBar1.Value.ToString() + "%"; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| using (var stream = new MemoryStream(System.IO.File.ReadAllBytes(dataDir + "SampleBook.xlsx"))) | |
| { | |
| this.grid.ImportExcelFile(stream); | |
| this.grid.ExportExcelFile(dataDir + "SampleOutput_out.xlsx"); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| public partial class loadingevent : basicForm | |
| { | |
| public loadingevent() | |
| { | |
| InitializeComponent(); | |
| gridDesktop1.Width = 800; | |
| gridDesktop1.Height = 800; | |
| gridDesktop1.ShowImportMessage = false; | |
| this.gridDesktop1.FailLoadFile += GridDesktop1_FailLoadFile; | |
| this.gridDesktop1.FinishLoadFile += GridDesktop1_FinishLoadFile; | |
| this.gridDesktop1.FinishCalculate += GridDesktop1_FinishCalculate; | |
| this.gridDesktop1.BeforeLoadFile += GridDesktop1_BeforeLoadFile; | |
| this.gridDesktop1.BeforeCalculate += GridDesktop1_BeforeCalculate; | |
| gridDesktop1.ImportExcelFile(LoadingHelper.getTestFile("loading-event.xlsx"), "wrongpassword", null, true, true); | |
| this.Text = " load event test"; | |
| } | |
| private void GridDesktop1_BeforeCalculate(object sender, Aspose.Cells.GridDesktop.WorkBookEvents args) | |
| { | |
| string value = this.gridDesktop1.GetActiveWorksheet().Cells["B5"].StringValue; | |
| this.gridDesktop1.GetActiveWorksheet().Cells["B5"].PutValue(value + " -> before calculate, \n"); | |
| } | |
| private void GridDesktop1_BeforeLoadFile(object sender, Aspose.Cells.GridDesktop.WorkBookEvents args) | |
| { | |
| string value = this.gridDesktop1.GetActiveWorksheet().Cells["B5"].StringValue; | |
| this.gridDesktop1.GetActiveWorksheet().Cells["B5"].PutValue(value + " -> before loadfile, \n"); | |
| } | |
| private void GridDesktop1_FinishCalculate(object sender, Aspose.Cells.GridDesktop.WorkBookEvents args) | |
| { | |
| string value = this.gridDesktop1.GetActiveWorksheet().Cells["B5"].StringValue; | |
| this.gridDesktop1.GetActiveWorksheet().Cells["B5"].PutValue(value + " -> finish calculate, \n"); | |
| } | |
| private void GridDesktop1_FinishLoadFile(object sender, Aspose.Cells.GridDesktop.WorkBookEvents args) | |
| { | |
| string value = this.gridDesktop1.GetActiveWorksheet().Cells["B5"].StringValue; | |
| this.gridDesktop1.GetActiveWorksheet().Cells["B5"].PutValue(value + " -> finish loadfile, \n"); | |
| } | |
| private void GridDesktop1_FailLoadFile(object sender, String s) | |
| {//try correct password | |
| MessageBox.Show("fail load the file "+s+",now we try another password"); | |
| gridDesktop1.ImportExcelFile(LoadingHelper.getTestFile("loading-event.xlsx"), "pwd456", null, false, true); | |
| } | |
| } | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Filter all drawing objects(including Chart, Picture, OleObject and all other drawing objects) from the workbook. | |
| gridDesktop1.LoadDataFilter = GridLoadDataFilterOptions.All&~GridLoadDataFilterOptions.Drawing; | |
| //here is another example ,if we want to filter to show styles and values only, we can use the below code ,notice here we use | | |
| // gridDesktop1.LoadDataFilter = GridLoadDataFilterOptions.CellValue | GridLoadDataFilterOptions.Style; | |
| gridDesktop1.ImportExcelFile("5472489.xlsx"); | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment