SQL Server FileStream转换为HTML [英] SQL Server FileStream to HTML

问题描述

大家好，

我正在.Net项目中工作，我们将SQL Server中的word，excel，pdf文档存储为varbinary.用户的要求之一是在文档中搜索单词，如果找到该单词，则应在浏览器中显示文档并突出显示匹配的单词.

我们已经有了Google Search Appliance，可以很好地返回匹配结果.我们有两个问题，

1)Google Search Appliance不会在浏览器中显示文档，因为它存储在数据库中，即使会显示，因为文档是word或excel格式，也会要求用户下载而不是直接打开.
2)由于无法在浏览器中向用户显示文档，因此无法突出显示文档中匹配的单词.

建议之一是将该varbinary转换为html，然后在将其转换为html后在浏览器窗口中显示，我可以使用html并突出显示匹配的单词.我不确定如何在不使用第三方工具的情况下将word，excel，pdf文档转换为html，如果我必须使用第三方工具，那么哪种工具是最好的.

非常感谢您提供任何帮助.

谢谢，
Tapan Desai

Hi All,

I am working on .Net project where we are storing word, excel, pdf documents in SQL Server as varbinary. One of the user requirement is to search word in document and if found then it should display document in browser with highlighting matching words.

We already have Google Search Appliance which does nice job of returning matching results. We have two problems,

1) Google Search Appliance does not show document in browser as its stored in database and even if it will show then because document is in word or excel format, will ask users to download it instead of directly opening it.
2) As I cannot show users document in browser, there is no way to highlight matching words in document.

One of the suggestion was to convert this varbinary into html and then show in browser window as once it’s converted in html I can play with html and highlight matching words. I am not sure how to convert word, excel, pdf documents into html without using third party tools and if I have to use third party tool then which tool is best.

I would really appreciate any help on this.

Thanks,
Tapan Desai

推荐答案

使用Lucene Dot net框架
这会有所帮助.

http://lucene.apache.org/lucene.net/ [

Go for the Lucene Dot net Framework
It will be helpful.

http://lucene.apache.org/lucene.net/[^]

这篇关于SQL Server FileStream转换为HTML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！