public static void Run() { // ExStart:1 // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Create directory if it is not already present. bool IsExists = System.IO.Directory.Exists(dataDir); if (!IsExists) { System.IO.Directory.CreateDirectory(dataDir); } // Create a new Workbook. Workbook workbook = new Workbook(); // Get the first worksheet in the workbook. Worksheet sheet = workbook.Worksheets[0]; // Add a new button to the worksheet. Aspose.Cells.Drawing.Button button = sheet.Shapes.AddButton(2, 0, 2, 0, 28, 80); // Set the caption of the button. button.Text = "Aspose"; // Set the Placement Type, the way the // Button is attached to the cells. button.Placement = PlacementType.FreeFloating; // Set the font name. button.Font.Name = "Tahoma"; // Set the caption string bold. button.Font.IsBold = true; // Set the color to blue. button.Font.Color = Color.Blue; // Set the hyperlink for the button. button.AddHyperlink("http:// Www.aspose.com/"); // Saves the file. workbook.Save(dataDir + "book1.out.xls"); // ExEnd:1 }
public static void Main(string[] args) { // The path to the documents directory. string dataDir = Path.GetFullPath("../../../Data/"); // Create directory if it is not already present. bool IsExists = System.IO.Directory.Exists(dataDir); if (!IsExists) { System.IO.Directory.CreateDirectory(dataDir); } //Create a new Workbook. Workbook workbook = new Workbook(); //Get the first worksheet in the workbook. Worksheet sheet = workbook.Worksheets[0]; //Add a new button to the worksheet. Aspose.Cells.Drawing.Button button = sheet.Shapes.AddButton(2, 0, 2, 0, 28, 80); //Set the caption of the button. button.Text = "Aspose"; //Set the Placement Type, the way the //button is attached to the cells. button.Placement = PlacementType.FreeFloating; //Set the font name. button.Font.Name = "Tahoma"; //Set the caption string bold. button.Font.IsBold = true; //Set the color to blue. button.Font.Color = Color.Blue; //Set the hyperlink for the button. button.AddHyperlink("http://www.aspose.com/"); //Saves the file. workbook.Save(dataDir + "book1.xls"); }