Hello,
It is not clear from your documentation whether you are still relying on jszip.js for Excel exports. We have found that this library has critical security vulnerabilities that have not been addressed by the FOSS developer who created it.
Please advise as to what you recommend.
Thanks.
Hi There,
I'm working on a web app and need to access the Excel column with letters instead of an index. I have gone through the documentation but didn't find how we can access the Excel column with alphabets such as A20
Could you please let me know if you have any functions or not?
Thanks,
Hello guys,
is it possible to define a conditional formatting on a whole column? E.g. if you want to set the background of a cell to yellow if the value is greater than 0 (see screenshot, column 'Fehlend').
In my case it's even more difficult because my whole datasource is coming from the server.
@(Html.Kendo().Spreadsheet()
.Name("bestandsliste")
.Columns(3)
.HtmlAttributes(new { style = "width:100%" })
.Sheets(x =>
{
x.Add()
.Name("Bestandsliste")
.Columns(y =>
{
y.Add().Width(400);
y.Add().Width(120);
y.Add().Width(120);
y.Add().Width(120);
})
.DataSource<Fahnenbestand>(y => y
.Custom()
.Sort(z => z.Add(a => a.Fahnenkategorie))
.Transport(z => z.Read("spreadsheet_onRead"))
)
.FrozenRows(1)
.Rows(y =>
{
y.Add().Height(30).Cells(z =>
{
z.Add().FontSize(20).TextAlign(SpreadsheetTextAlign.Center);
z.Add().FontSize(20).TextAlign(SpreadsheetTextAlign.Center);
z.Add().FontSize(20).TextAlign(SpreadsheetTextAlign.Center);
z.Add().FontSize(20).TextAlign(SpreadsheetTextAlign.Center);
});
});
})
.Sheetsbar(false)
.Toolbar(false)
)
function spreadsheet_onRead(options) {
$.ajax({
url: `@ViewData[ViewDataVariables.UrlWebApi]/FlagCategory/GetOverviewAllFlagsAsSpreadsheet`,
headers: { 'Authorization': '@token' },
success: function (result) {
var sheet = kendoSpreadSheetBestandsliste.activeSheet();
sheet.resize(result.Total + 5, 3);
options.success(result.Data);
},
error: function (result) {
options.error(result);
}
});
}
I already check the css of the cells. Indeed I can simply set the background color of the cells of a specific column by a condition via jquery (like "if value greater 0, set background yellow"), but the cells carry very little informations. It's not possible to prove if the cell I'm currently looking is belonging to correct column. It would be easy if there would be an attribute like aria-labeledby="COLUMNHEADERCELL" but that's not the case.
<div class="k-spreadsheet-cell" style="[..]"><div class="k-vertical-align-bottom">1</div></div>
Maybe there is a solution to get all cells of one column via the api of my spreadsheet object? Looking forward to hearing from you.
Best regards,
Daniel
Hey guys,
I'm currently working newly with the kendo spreadsheet. Default amount of rows is 200 and I can define it programatically, I know.
My spreadsheet has a datasource. Is there a smart solution to handle the count of rows by it's datasource? So if the datasource has 400 elements, that my spreadsheet increase the rows?
Best Regards,
Daniel
@(Html.Kendo().Spreadsheet()
.Name("bestandsliste")
.HtmlAttributes(new { style = "width:100%" })
.Sheets(x =>
{
x.Add()
.Name("Bestandsliste")
.DataSource<Fahnenbestand>(y => y
.Custom()
.Transport(z => z.Read("spreadsheet_onRead"))
);
})
.Sheetsbar(false)
.Toolbar(false)
)
function spreadsheet_onRead(options) {
$.ajax({
url: `@ViewData[ViewDataVariables.UrlWebApi]/FlagCategory/GetOverviewAllFlagsAsSpreadsheet`,
headers: { 'Authorization': '@token' },
success: function (result) {
console.log(options);
console.log(options.rows);
options.success(result.Data);
},
error: function (result) {
options.error(result);
}
});
}
Navigation imporvemtns to speedsheet.
Is it possible to only move between "open cells for input. " With fx. using tab or enter.
When you are input finance data. It would be nice, that with a tab, it only moves between open cell. Is this possible.
reg. jakob
Hi all,
I'm trying to understand if it is possible to create a Spreadsheet with the RadSpreadProcessing library and work with it in a web environment. I saw from older posts that there was a Telerik.Web.Spreadsheet library that supported this integration, but it seems that it is not directly supported now with .NET 6.
I need to show a spreadsheet to the user on a browser, with support for formulas, macros, excel graphs, workbook/worksheet protection, autofit of columns, basically everything that can be done with excel. From the documentation it seems that many of the features that I need are not supported by Telerik UI Web, but are supported by the RadSpreadProcessing. Is it correct? Is there a way to implement all this with the Web UI libraries?
Thank you everyone in advance!
Tommaso
Hello, I would like to know if there is any way to extract the graphs from an excel sheet. I have managed to export the content of the excel sheet but I have not been able to export the graph that is generated there
So far this is the code I handle
byte[] bytes = System.IO.File.ReadAllBytes(@"path"); Stream stream2 = new MemoryStream(bytes); Workbook workbook = Workbook.Load(stream2, ".xlsx"); Telerik.Windows.Documents.Spreadsheet.Model.Workbook document = workbook.ToDocument(); document.ActiveSheet = document.Worksheets.First(sheet => sheet.Name == "Rep.F3"); foreach (Telerik.Windows.Documents.Spreadsheet.Model.Worksheet sheet in document.Worksheets) { if (sheet.Name != "Rep.F3") { sheet.Visibility = Telerik.Windows.Documents.Spreadsheet.Model.SheetVisibility.Hidden; //document.Worksheets.Remove(sheet); } else { var shapes = sheet.Shapes; var img= sheet.Images; sheet.WorksheetPageSetup.PaperType = Telerik.Windows.Documents.Model.PaperTypes.A4; sheet.WorksheetPageSetup.PageOrientation = Telerik.Windows.Documents.Model.PageOrientation.Portrait; sheet.WorksheetPageSetup.CenterHorizontally = true; sheet.WorksheetPageSetup.PrintOptions.PrintGridlines = false; sheet.WorksheetPageSetup.ScaleFactor = new Telerik.Documents.Primitives.Size(0.9, 1); sheet.WorksheetPageSetup.Margins = new Telerik.Windows.Documents.Spreadsheet.Model.Printing.PageMargins(0 , 20, 0, 0); } }
I have tried to get the list of images and forms but it does not return any result
Our customers using the spreadsheet copy/paste values in the Spreadsheet (ASP. NET CORE)
Sometimes pasted decimal separator is ".", sometimes is the ",".
Is there a way to search and replace the pasted values from "," to ".", or, if not, to search and replace in Spreadsheet ?
Hi Team,
We are using Telerik reporting service license and have developed reports but our reports are not having excel export option, however the same is working with the trial version of the product in our local environment. but not with the licensed version.
We are using Asp.Net core version 3.1.
We have tried below articles but no luck so far:
1. https://docs.telerik.com/reporting/using-reports-in-applications/dot-net-core-support
2. https://docs.telerik.com/reporting/knowledge-base/missing-docx-xlsx-pptx-xps-export-options
3. https://www.telerik.com/forums/telerik-report-only-have-pdf-excel-and-word-are-missing
Any urgent help will be appreciated.
Thanks,
Markandey Pandey