Hi Manolo,
Thanks for Contacting Syncfusion support.
Please find the following response for your queries:
Query #1: 1. In Agenda, how can I hide tome column and add more custom columns?
You can add the custom columns and hide the time column by using our QueryCellInfo feature. Please refer to the following code example to add custom column and hide time column.
<Code>
<script>
function OnCheckInfo(args) {
if (args.model.currentView == "agenda") {
if (args.requestType == "agendacells" && args.cellType == "agendaheadercells") {
if (args.element.hasClass("e-timecolumn"))
args.element.addClass("hide-time-column"); // Hiding time header column
}
if (args.requestType == "agendacells" && args.cellType == "agendatimecell") {
args.element.addClass("hide-time-column"); // Hiding time column
}
if (args.requestType == "agendacells" && args.cellType == "agendaeventcell") {
var customDesign = "<td class='e-agendacells loccolumn'><div class='e-textwrapper'><span>" + args.appointment.Location + "</span></div></td><td class='e-agendacells desccolumn'><div class='e-textwrapper'><span>" + args.appointment.Description + "</span></div></td>"; // to add additional field for each appointments
$(args.element).after(customDesign);
}
if (args.requestType == "agendacells" && args.cellType == "agendaheadercells" && $(args.element).hasClass("e-eventcolumn") && $(".e-headercells.loccolumn").length == 0) {
var customDesign1 = "<td class='e-headercells loccolumn'><div class='e-textwrapper'><b>Event Location</b></div></td><td class='e-headercells desccolumn'><div class='e-textwrapper'><b>Event Description</b></div></td>"; //to add header for additional columns
args.element.after(customDesign1);
}
}
}
</script>
<style>
.hide-time-column {
display: none;
}
</style>
</Code>
Please look into our below UG links to know more about the QueryCellInfo feature details.
Query #2: In excel export, how can I hide custom columns?
By default we will display the appointment details based on the “AppointmentsData class” fields alone in the in excel exported file. Therefore, please define the AppointmentsData class with required field to be exported. For example, we have excluded the description field in the AppointmentsData class and which is not available in the exported file.
<Code>
public class AppointmentData
{
public int Id { get; set; }
public string Subject { get; set; }
public string StartTime { get; set; }
public string EndTime { get; set; }
public bool? AllDay { get; set; }
public bool? Recurrence { get; set; }
public string RecurrenceRule { get; set; }
public string Location { get; set; }
}
</Code>
Query #3: The date column.... can be grouped by week number?
Please refer to the following code example to get the week number of the date and based on that you can customize the date column as per your wish.
<Code>
<script>
function OnCreate() {
var obj = $("#Schedule1").data("ejSchedule");
var date = new Date(obj.currentDate());
var weekFirst = new Date(date.getFullYear(), date.getMonth(), date.getDate());
for (var a = 0, len = obj._dateRender.length / 7 ; a < len; a++) {
var weekDate = weekFirst._currentWeekDates(obj._firstdayofweek);
var weekNo = Math.ceil((((weekDate.start - new Date(weekDate.start.getFullYear(), 0, 1)) / 86400000) + new Date(weekDate.start.getFullYear(), 0, 1).getDay() + 1) / 7);
var weekNumber = (weekNo > 52) ? weekNo - 52 : weekNo; // Here you can get the weekNumber
// Add your customized code to group the date column as per your wish
}
}
</script>
</Code>
We have prepared the sample with the above code example, which can be downloaded from the following location.
Kindly try with the above sample and let me know if you need any further assistance on this.
Regards,
Velmurugan
