excelreader.ascx

Excel Reader for Portal Rainbow

<%@ Control language="c#" Inherits="Rainbow.DesktopModules.OneFileModule" %>
<%@ Register TagPrefix="cc1" Namespace="Rainbow.UI.WebControls" Assembly="Rainbow" %>
<script language="C#" runat="server">

    public override Guid GuidID 
    {
        get
        {
            return new Guid("{1E03D793-5A01-4f35-811D-5D23EF66618D}");
        }
    }

	void Page_Load(Object sender, EventArgs e)
	{
		try
		{
			// get the settings for this module
			InitSettings(SettingsType.Str);

			if (SettingsExists)
			{
			    // Settings are : ExcelFile + RangeName
		
				// pick the Excel file from settings adding the path from the portal Data directory
				Rainbow.UI.DataTypes.PortalUrlDataType pt;
				pt = new Rainbow.UI.DataTypes.PortalUrlDataType();
				pt.Value = GetSetting("ExcelFile");
				String sExcelFile = Server.MapPath(Rainbow.Configuration.PortalSettings.SolutionPath + "/" + pt.FullPath);
	            
				// Create connection
				String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
					"Data Source=" + sExcelFile + ";" + "Extended Properties=Excel 8.0;";
				System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection(sConnectionString);
				objConn.Open();

				// The code to follow uses a SQL SELECT command to display the data from the worksheet.
				System.Data.OleDb.OleDbCommand objCmdSelect =new System.Data.OleDb.OleDbCommand("SELECT * FROM " + GetSetting("RangeName"), objConn);
				System.Data.OleDb.OleDbDataAdapter objAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
				objAdapter1.SelectCommand = objCmdSelect;

				// Create new DataSet to hold information from the worksheet.
				System.Data.DataSet objDataset1 = new System.Data.DataSet();
				objAdapter1.Fill(objDataset1, "XLData");

				// Bind data to DataGrid control.
				DataGrid1.DataSource = objDataset1.Tables[0].DefaultView;
				DataGrid1.DataBind();

				// Clean up objects.
				objConn.Close();
			}
		}
		
		catch
		{
		}
	}

</script>
<cc1:DesktopModuleTitle EditText="Edit" EditUrl="~/DesktopModules/PropertyPage.aspx" PropertiesText="PROPERTIES" PropertiesUrl="~/DesktopModules/PropertyPage.aspx" runat="server" ID="ModuleTitle" />
<asp:DataGrid id="DataGrid1" runat="server"></asp:DataGrid>