Is it possible to name multiple sheets in Excel export?

Comments

• gpi

  March 2017 edited 10:15PM

  FR doesn't have such feature. You need to modify FR's sources
• LurkingKiwi Wellington, New Zealand

  March 2017 edited 10:15PM

  gpi wrote: »

  FR doesn't have such feature. You need to modify FR's sources

  Thanks, I did try to find the code in FR which named the sheets but didn't succeed.
• gpi

  March 2017 edited 10:15PM

  For example for frxExportXLSX.pas:

  var
    f, i, j, k, l, x, y, dx, dy: Integer;
    Obj: TfrxIEMObject;
    r: TfrxRect;
    MCells: array of TRect; // merged cells
    StrList: TStrings;
    StylesMap: array of Integer;
    Pictures: TList; // of TfrxIEMObject
    s: string;
    ss: TStream; // xl/worksheets/sheetXXX.xml
    style: TfrxIEMStyle;
    rotor, td: string;
    TempThousandSeparator, TempDecimalSeparator: Char;
  begin
    WriteStr(FContentTypes, '<Override PartName="/xl/worksheets/sheet' + IntToStr(m.Index) +
      '.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml' +
      '.worksheet+xml"/>');
  
    if ReportPages and (ChunkSize = 0) and not SingleSheet then
      WriteStr(FWorkbook, Format('<sheet name="%s" sheetId="%d" r:id="rId%d"/>',
        [Report.PreviewPages.Page[m.Index - 1].Name, m.Index, m.Index], SetFormat))
    else
      WriteStr(FWorkbook, Format('<sheet name="Page %d" sheetId="%d" r:id="rId%d"/>',
        [m.Index, m.Index, m.Index], SetFormat));
  
• Sokianos

  August 2023

  Good evening, I want to find the setting to break the report into a sheet, how do I do it?