private async Task <Aspose.Cells.Drawing.Picture> StyleImageCheck(Aspose.Cells.Drawing.Picture pic)
{
pic.Height = 20;
pic.Width = 20;
pic.Top = 5;
pic.Left = 40;
return(await Task.FromResult(pic));
}
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);
}
// Instantiate a new workbook
Workbook workbook = new Workbook();
// Get the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
// Insert a string value to a cell
worksheet.Cells["C2"].PutValue("Image Hyperlink");
// Set the 4th row height
worksheet.Cells.SetRowHeight(3, 100);
// Set the C column width
worksheet.Cells.SetColumnWidth(2, 21);
// Add a picture to the C4 cell
int index = worksheet.Pictures.Add(3, 2, 4, 3, dataDir + "aspose-logo.jpg");
// Get the picture object
Aspose.Cells.Drawing.Picture pic = worksheet.Pictures[index];
// Set the placement type
pic.Placement = PlacementType.FreeFloating;
// Add an image hyperlink
Aspose.Cells.Hyperlink hlink = pic.AddHyperlink("http:// Www.aspose.com/");
// Specify the screen tip
hlink.ScreenTip = "Click to go to Aspose site";
dataDir = dataDir + "ImageHyperlink.out.xls";
// Save the Excel file
workbook.Save(dataDir);
// ExEnd:1
Console.WriteLine("\nProcess completed successfully.\nFile saved at " + dataDir);
}
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);
}
//Instantiate a new workbook
Workbook workbook = new Workbook();
//Get the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Insert a string value to a cell
worksheet.Cells["C2"].PutValue("Image Hyperlink");
//Set the 4th row height
worksheet.Cells.SetRowHeight(3, 100);
//Set the C column width
worksheet.Cells.SetColumnWidth(2, 21);
//Add a picture to the C4 cell
int index = worksheet.Pictures.Add(3, 2, 4, 3, dataDir + "aspose-logo.jpg");
//Get the picture object
Aspose.Cells.Drawing.Picture pic = worksheet.Pictures[index];
//Set the placement type
pic.Placement = PlacementType.FreeFloating;
//Add an image hyperlink
Aspose.Cells.Hyperlink hlink = pic.AddHyperlink("http://www.aspose.com/");
//Specify the screen tip
hlink.ScreenTip = "Click to go to Aspose site";
//Save the Excel file
workbook.Save(dataDir + "ImageHyperlink.xls");
}
public static void Run()
{
//Source directory
string sourceDir = RunExamples.Get_SourceDirectory();
//Output directory
string outputDir = RunExamples.Get_OutputDirectory();
// Instantiate a new workbook
Workbook workbook = new Workbook();
// Get the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
// Insert a string value to a cell
worksheet.Cells["C2"].PutValue("Image Hyperlink");
// Set the 4th row height
worksheet.Cells.SetRowHeight(3, 100);
// Set the C column width
worksheet.Cells.SetColumnWidth(2, 21);
// Add a picture to the C4 cell
int index = worksheet.Pictures.Add(3, 2, 4, 3, sourceDir + "sampleAddImageHyperlinks.jpg");
// Get the picture object
Aspose.Cells.Drawing.Picture pic = worksheet.Pictures[index];
// Set the placement type
pic.Placement = PlacementType.FreeFloating;
// Add an image hyperlink
Aspose.Cells.Hyperlink hlink = pic.AddHyperlink("https://www.aspose.com");
// Specify the screen tip
hlink.ScreenTip = "Click to go to Aspose site";
// Save the Excel file
workbook.Save(outputDir + "outputAddImageHyperlinks.xlsx");
Console.WriteLine("AddImageHyperlinks executed successfully.\r\n");
}
public async Task <ActionResult> ExportExcelDetailAspose([FromQuery] string articleCateID, string articleID, int checkExport)
{
var data = await _articleService.GetArticleByID(articleCateID, articleID.ToInt());
var path = Path.Combine(_webHostEnvironment.ContentRootPath, "Resources\\Template\\Article\\ArticleDetailTemplate.xlsx");
WorkbookDesigner designer = new WorkbookDesigner();
designer.Workbook = new Workbook(path);
Cell cell = designer.Workbook.Worksheets[0].Cells["A1"];
Worksheet ws = designer.Workbook.Worksheets[0];
Cells cells = ws.Cells;
designer.SetDataSource("result", data);
designer.Process();
Style style = designer.Workbook.CreateStyle();
style.IsTextWrapped = true;
style.VerticalAlignment = TextAlignmentType.Center;
style.HorizontalAlignment = TextAlignmentType.Center;
style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
style.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
style.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
style.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
StyleFlag flg = new StyleFlag();
flg.All = true;
int index = 2;
ws.Cells["A" + (index)].PutValue(data.Article_Cate_ID);
ws.Cells["B" + (index)].PutValue(data.Article_Name);
ws.Cells["C" + (index)].PutValue(data.Content);
ws.Cells["E" + (index)].PutValue(data.Update_By);
ws.Cells["F" + (index)].PutValue(data.Update_Time.ToString());
string folderImage = _webHostEnvironment.WebRootPath + "\\uploaded\\images\\article\\";
string folderVideo = _webHostEnvironment.WebRootPath + "\\uploaded\\video\\article\\";
if (!string.IsNullOrEmpty(data.FileImages))
{
string[] listImage = data.FileImages.Split(";");
foreach (var image in listImage)
{
if (image != "")
{
Aspose.Cells.Drawing.Picture pic = ws.Pictures[ws.Pictures.Add(index - 1, 6, folderImage + image)];
pic = await StyleImageExcel(pic);
ws.Cells.SetRowHeight(index - 1, 45);
index++;
}
}
}
int index1 = 2;
if (!string.IsNullOrEmpty(data.FileVideos))
{
string[] listVideo = data.FileVideos.Split(";");
foreach (var video in listVideo)
{
if (video != "")
{
Aspose.Cells.Drawing.Picture pic = ws.Pictures[ws.Pictures.Add(index1 - 1, 7, folderVideo + "video.jpg")];
pic = await StyleImageExcel(pic);
ws.Cells.SetRowHeight(index1 - 1, 45);
index1++;
}
}
}
int index3 = index >= index1 ? index : index1;
if (!string.IsNullOrEmpty(data.FileImages) || !string.IsNullOrEmpty(data.FileVideos))
{
// Merge column not image, video
int[] number = { 0, 1, 2, 3, 4, 5 };
foreach (var item in number)
{
cells.Merge(1, item, index3 - 2, 1);
}
// Set style
for (int i = 1; i < index3 - 1; i++)
{
string[] text = { "A", "B", "C", "D", "E", "F", "G", "H" };
foreach (var item in text)
{
ws.Cells[item + (i + 1)].SetStyle(style, flg);
}
}
}
string file = _dropzoneService.CheckTrueFalse(data.Status);
Aspose.Cells.Drawing.Picture picStatus = ws.Pictures[ws.Pictures.Add(1, 3, file)];
picStatus = await StyleImageCheck(picStatus);
picStatus.Top = (index3 - 2 == 0 ? 1 : index3 - 2) * 20;
MemoryStream stream = new MemoryStream();
string fileKind = "";
string fileExtension = "";
if (checkExport == 1)
{
designer.Workbook.Save(stream, SaveFormat.Xlsx);
fileKind = "application/xlsx";
fileExtension = ".xlsx";
}
if (checkExport == 2)
{
// custom size ( width: in, height: in )
ws.PageSetup.FitToPagesTall = 0;
ws.PageSetup.SetHeader(0, "&D &T");
ws.PageSetup.SetHeader(1, "&B Article");
ws.PageSetup.SetFooter(0, "&B SYSTEM BY MINH HIEU");
ws.PageSetup.SetFooter(2, "&P/&N");
ws.PageSetup.PrintQuality = 1200;
designer.Workbook.Save(stream, SaveFormat.Pdf);
fileKind = "application/pdf";
fileExtension = ".pdf";
}
byte[] result = stream.ToArray();
return(File(result, fileKind, "Article_Detail_" + DateTime.Now.ToString("dd_MM_yyyy_HH_mm_ss") + fileExtension));
}
public async Task <ActionResult> ExportExcelListAspose([FromQuery] PaginationParams param, string text, int checkExport, string articleCateID, string articleName, int checkSearch)
{
PageListUtility <Article_Dto> data;
if (checkSearch == 1)
{
data = await _articleService.GetArticleWithPaginations(param, text, false);
}
else
{
data = await _articleService.SearchArticleWithPaginations(param, articleCateID, articleName, false);
}
var path = Path.Combine(_webHostEnvironment.ContentRootPath, "Resources\\Template\\Article\\ArticleListTemplate.xlsx");
WorkbookDesigner designer = new WorkbookDesigner();
designer.Workbook = new Workbook(path);
Cell cell = designer.Workbook.Worksheets[0].Cells["A1"];
Worksheet ws = designer.Workbook.Worksheets[0];
designer.SetDataSource("result", data.Result);
designer.Process();
Style style = ws.Cells["F2"].GetStyle();
style.Custom = "dd/MM/yyyy hh:mm:ss";
for (int i = 1; i <= data.Result.Count; i++)
{
ws.Cells["F" + (i + 1)].SetStyle(style);
}
int index = 1;
foreach (var item in data.Result)
{
if (item.Content.Length > 70)
{
ws.AutoFitRow(index);
}
else
{
ws.Cells.SetRowHeight(index, 22.5);
}
string file = _dropzoneService.CheckTrueFalse(item.Status);
Aspose.Cells.Drawing.Picture pic = ws.Pictures[ws.Pictures.Add(index, 3, file)];
pic = await StyleImageCheck(pic);
index++;
}
MemoryStream stream = new MemoryStream();
string fileKind = "";
string fileExtension = "";
if (checkExport == 1)
{
designer.Workbook.Save(stream, SaveFormat.Xlsx);
fileKind = "application/xlsx";
fileExtension = ".xlsx";
}
if (checkExport == 2)
{
// custom size ( width: in, height: in )
ws.PageSetup.FitToPagesTall = 0;
ws.PageSetup.SetHeader(0, "&D &T");
ws.PageSetup.SetHeader(1, "&B Article");
ws.PageSetup.SetFooter(0, "&B SYSTEM BY MINH HIEU");
ws.PageSetup.SetFooter(2, "&P/&N");
ws.PageSetup.PrintQuality = 1200;
designer.Workbook.Save(stream, SaveFormat.Pdf);
fileKind = "application/pdf";
fileExtension = ".pdf";
}
byte[] result = stream.ToArray();
return(File(result, fileKind, "Article_List_" + DateTime.Now.ToString("dd_MM_yyyy_HH_mm_ss") + fileExtension));
}
