如何从Excel中选择数据并将其部署在门户中 [英] How to pick data from excel and deploy it in portal

问题描述

嘿，我必须从excel中选择数据并将其部署在portal(site)中，我们该怎么做?

Hey, i have to pick data from excel and deploy the same in portal(site), how can we do that?

推荐答案

有几种解决方案.

1.)如果在WebServer上安装了Excel，则可以使用PIA.虽然不推荐
2.)如果Excel文件采用某种XML格式，则可以编写自己的Reader.
3.)您可以使用市场上已经存在的解决方案.领先的解决方案将是ASPOSE.CELLS或SpreadsheetGear，但我认为它们两个都花了一半的钱.也许您会在这里免费找到类似的东西.

There are several solutions.

1.) You can use the PIA if Excel is installed on your WebServer. Not recommended though
2.) If the Excel Files are in some kind of XML-Format, you can write your own Reader.
3.) You can use solutions for this already on the market. The leading solution would be ASPOSE.CELLS or SpreadsheetGear, but i think both of them cost half a fortune. Maybe you will find something similar on here for free though.

这篇关于如何从Excel中选择数据并将其部署在门户中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！