将Excel对象复制到SpreadJS

你可以从Excel中复制Excel样式和浮动对象，然后粘贴到SpreadJS中的表单中。这使得您可以很容易地复制Excel样式和浮动对象，而无需导入整个表格。您可以通过设置 allowCopyPasteExcelStyle 属性为true来启用样式和对象的复制和粘贴。

Excel的样式

将 allowCopyPasteExcelStyle 属性设置为true，允许复制和粘贴样式。

spread.options.allowCopyPasteExcelStyle = true;

下表显示了从Excel复制并粘贴到SpreadJS中的样式选项。

	Google Chrome	Mozilla Firefox	Microsoft Edge	Microsoft Internet Explorer
backColor	支持	支持	支持	支持
foreColor	支持	支持	支持	支持
font	支持	支持	支持	支持
vAlign	top -> top center -> center bottom -> bottom justify -> bottom distributed -> bottom	top -> center center -> center bottom -> center justify -> center distributed -> center	top -> top center -> center bottom -> bottom justify -> bottom distributed -> bottom	top -> top center -> center bottom -> bottom justify -> bottom distributed -> bottom
hAlign	left -> left center -> center right -> right general -> general fill -> general justify -> general center across selection -> general distributed -> general	left -> left center -> left right -> left general -> left fill -> left justify -> left center across selection -> center distributed -> left	left -> left center -> center right -> right general -> general fill -> general justify -> general center across selection -> general distributed -> general	left -> left center -> center right -> right general -> general fill -> general justify -> general center across selection -> general distributed -> general
borderLeft	thin -> medium medium -> medium dashed -> mediumDashed dotted -> dotted thick -> medium double -> double hair -> None mediumDashed -> mediumDashed dashDot -> None mediumDashDot -> None dashDotDot -> None mediumDashDotDot -> None slantedDashDot -> None	thin -> medium medium -> medium dashed -> mediumDashed dotted -> dotted thick -> medium double -> double hair -> None mediumDashed -> mediumDashed dashDot -> None mediumDashDot -> None dashDotDot -> None mediumDashDotDot -> None slantedDashDot -> None	thin -> medium medium -> medium dashed -> mediumDashed dotted -> dotted thick -> medium double -> double hair -> None mediumDashed -> mediumDashed dashDot -> None mediumDashDot -> None dashDotDot -> None mediumDashDotDot -> None slantedDashDot -> None	thin -> medium medium -> medium dashed -> mediumDashed dotted -> dotted thick -> medium double -> double hair -> None mediumDashed -> mediumDashed dashDot -> None mediumDashDot -> None dashDotDot -> None mediumDashDotDot -> None slantedDashDot -> None
borderRight
borderTop
borderBottom
textDecoration	strikethrough -> lineThrough single -> underline double -> underline single accounting -> underline double accounting -> underline	strikethrough -> lineThrough single -> underline double -> underline single accounting -> underline double accounting -> underline	strikethrough -> lineThrough single -> underline double -> underline single accounting -> underline double accounting -> underline	strikethrough -> lineThrough single -> underline double -> underline single accounting -> underline double accounting -> underline

浮动对象

通过设置 allowCopyPasteExcelStyle 属性为true，也可以从Excel复制浮动对象并粘贴到SpreadJS表单中。请注意，您可以从Excel复制图表和形状，并将它们作为图像粘贴到SpreadJS中。默认情况下，这个特性已经在SpreadJS中启用了，但是它不支持从SpreadJS复制和粘贴图片到Excel。

你可以在Windows和Mac中使用Ctrl + V和Command + V键盘组合，同时将图片粘贴到SpreadJS表单中，如下图所示。

可以看到，在SpreadJS中粘贴原始图像时，它的大小和内容没有受到影响。但是，您可以使用调整大小处理程序来调整已粘贴图像的大小。图像在表单中的位置由SpreadJS的活动单元格决定。你可以在SpreadJS表单中一个一个的复制粘贴图像，或者从excelor复制所有的图像，并将它们作为一个大图像粘贴到表单中。