Reading Hindi excel file
<p>I have an excel file in which there are text and images in Hindi font. Now, my requirement is to read the excel file and store the binary data in database or anything which later can be converted into the same font. </p>

<p>When I read the excel in normal way through C# it gets some roman characters for hindi fonts without doing any encoding or decoding.</p>

<p>I use this code to read the excel file: </p>

<pre><code>string fileName = string.Format("{0}", Directory.GetCurrentDirectory()); 
var connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", fileName); 
var adapter = new OleDbDataAdapter("SELECT * FROM [workSheetNameHere$]", connectionString);
var ds = new DataSet(); 
adapter.Fill(ds, "anyNameHere");
DataTable data = ds.Tables["anyNameHere"];
</code></pre>

<p>EDIT: This code is used by me to read the excel file</p>

<pre><code>string fileName = string.Format("{0}", Directory.GetCurrentDirectory()); 
var connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; 
data source={0};    
Extended Properties=Excel 8.0;", fileName);
var adapter = new OleDbDataAdapter("SELECT * FROM [workSheetNameHere$]",
                                                        connectionString); 
var ds = new DataSet(); 
adapter.Fill(ds, "anyNameHere"); 
DataTable data = ds.Tables["anyNameHere"];
</code></pre>
