Spreadjs打印excel，模板设置横向打印，前台js中也设置了横向，打印预览是纵向

收藏

         var orientation = spread.sheets[0].printInfo().orientation();
         if (orientation == 2) {
            printInfo.orientation(GC.Spread.Sheets.Print.PrintPageOrientation.landscape);
         } else {
            printInfo.orientation(GC.Spread.Sheets.Print.PrintPageOrientation.portrait);
         }

image.png951478881.png

以下是我全部的代码

<script type="text/javascript">

   var spread = new GC.Spread.Sheets.Workbook(document.getElementById("printArea1"));

   var excelIo = new GC.Spread.Excel.IO();
   var excelFilePath = "https://localhost:7218/EXCEL/test1.xlsx";
   var xhr = new XMLHttpRequest();
   xhr.open('GET', excelFilePath, true);
   xhr.responseType = 'blob';
   xhr.onload = function (e) {
         if (this.status == 200) {
            // get binary data as a response
            var blob = this.response;
            // convert Excel to JSON
            excelIo.open(blob, function (json) {
               var workbookObj = json;
               spread.fromJSON(workbookObj);
            }, function (e) {
               // process error
               alert(e.errorMessage);
            }, {});
         }
   };

   xhr.send();
   //spread.name = "555.xlsx";

   document.getElementById('print1').onclick = function () {
         var sheet = spread.sheets[0];
         var printInfo = sheet.printInfo();
         printInfo.showRowHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide);
         printInfo.showColumnHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide);

         var margintop = printInfo.margin().top;
         var marginbottom = printInfo.margin().bottom;
         var marginleft = printInfo.margin().left;
         var marginright = printInfo.margin().right;
         var marginheader = printInfo.margin().header;
         var marginfooter = printInfo.margin().footer;

         printInfo.margin({ top: 20, bottom: 20, left: 20, right: 20, header: 1, footer: 1 });
         printInfo.showBorder(false);

         var printHeaderRight = printInfo.pageHeaderFooter().normal.header.right;
         printHeaderRight = printHeaderRight.replaceAll("\r\n", "")

         var printFootRight = printInfo.pageHeaderFooter().normal.footer.right;
         if (printFootRight == "&F") {
            printFootRight = "調査計画表（２）_51_00_20241122145348.xlsx";
         }

         var orientation = spread.sheets[0].printInfo().orientation();
         if (orientation == 2) {
            printInfo.orientation(GC.Spread.Sheets.Print.PrintPageOrientation.landscape);
         } else {
            printInfo.orientation(GC.Spread.Sheets.Print.PrintPageOrientation.portrait);
         }


         printInfo.pageHeaderFooter({
            normal: {
               header: {
                     left: "",
                     center: "",
                     right: printHeaderRight
               },
               footer: {
                     center: "",
                     right: '調査計画表（２）_51_00_20241122145348.xlsx'
               }
            }
         });
         //spread.name = "555.xlsx";
         spread.print();
   };

   document.getElementById('save1').onclick = function () {
         var worksheet = spread.sheets[0];
         worksheet.getPageSetup().setIsPercentScale(false);
         worksheet.getPageSetup().setFitToPagesWide(1);
         worksheet.isPrintLineVisible(true);
         spread.export(function (blob) {
            saveAs(blob, "sss.xlsx");
         }, function (e) {
            console.log(e);
         }, {
            fileType: GC.Spread.Sheets.FileType.excel
         });
   };

   document.getElementById('test').onclick = function () {

         $("#PageForm").attr("action", "Home/Privacy");
         $("#PageForm").submit();
   }

</script>

八嘎呀路 · 八嘎呀路

调一下浏览器的打印设置试试
image.png30997618.png

瑞雪 · 瑞雪

八嘎呀路发表于 2025-1-8 12:25
调一下浏览器的打印设置试试

这需要是手动调整，但是如果模板的横向纵向是不确定的，手动调整不现实吧

Matthew.Xue · Matthew.Xue

本帖最后由 Matthew.Xue 于 2025-1-8 16:50 编辑

您好，请问您说的打印预览是浏览器的打印预览，还是SpreadJS的打印预览呢？

SpreadJS的打印要借助浏览器的打印功能，SpreadJS中设置的那些打印选项，只会影响SpreadJS向浏览器的打印接口传输的图片，您在浏览器那里还需要再次设置打印的纸张方向、页边距等内容。
所以如果您说的是浏览器的打印预览，那么这是正常的现象，如果是SpreadJS的打印预览，请提供一个可复现的demo，我们会上报给研发修复~

瑞雪 · 瑞雪

Matthew.Xue 发表于 2025-1-8 16:46
您好，请问您说的打印预览是浏览器的打印预览，还是SpreadJS的打印预览呢？

SpreadJS的打印要借助浏览器 ...

好吧，那模板中的打印方向就废弃了是不

		自动登录	找回密码
密码			立即注册

[处理中] Spreadjs打印excel，模板设置横向打印，前台js中也设置了横向，打印预览是纵向

4 个回复