function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
VSK98VSK98 

I am getting second worksheet body is null using XML

Hello All,

I am working on download multiple sheets from the client side in lightning. But the second sheet coming up with null instead of values.

Snippet code: 
var template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet><x:ExcelWorksheet>x:Name>{sample}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheets><x:ActiveSheet>0</x:ActiveSheet></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body><body><table><tr><th>test</th></tr></table></body></html>';

Adv thanks,
VSK98