ASP.NET

Re: merge cells with same values in microsoft office interop excel

28-Mar-12 20:32

i created a report which exports to excel. it exports just fine. what i want to do now is merge the consecutive cells in a column which have the same values. how do i do this? please help me.

this is code that generates the excel body:

Protected Sub generateExcelBody(ByVal xcelworksheet As Microsoft.Office.Interop.Excel.Worksheet, ByVal recarray As Array, ByVal numofrecords As Integer)
    Dim chartrange As Microsoft.Office.Interop.Excel.Range
    chartrange = Nothing
    chartrange = xcelworksheet.Range("B5", "F5")
    chartrange.MergeCells = True
    chartrange.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft
    chartrange.VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter

    chartrange = Nothing
    chartrange = xcelworksheet.Range("A8", System.Reflection.Missing.Value)
    chartrange.FormulaR1C1 = "Record Series : " & hiddenrs.Value
    chartrange = Nothing
    chartrange = xcelworksheet.Range("A9", System.Reflection.Missing.Value)
    chartrange.FormulaR1C1 = "Department : " & hiddendept.Value
    chartrange = Nothing
    chartrange = xcelworksheet.Range("A10", System.Reflection.Missing.Value)
    chartrange.FormulaR1C1 = "Number of Records : " & numofrecords
    chartrange = Nothing
    chartrange = xcelworksheet.Range("A14", "F14")
    chartrange.Resize(numofrecords, 6).Value2 = recarray
    chartrange.Resize(numofrecords, 6).Borders(Microsoft.Office.Interop.Excel.XlBordersIndex.xlEdgeLeft).Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium
    chartrange.Resize(numofrecords, 6).Borders(Microsoft.Office.Interop.Excel.XlBordersIndex.xlEdgeRight).Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium
    chartrange.Resize(numofrecords, 6).Borders(Microsoft.Office.Interop.Excel.XlBordersIndex.xlInsideHorizontal).Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin
    chartrange.Resize(numofrecords, 6).Borders(Microsoft.Office.Interop.Excel.XlBordersIndex.xlInsideVertical).Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThin
    chartrange.Resize(numofrecords, 6).Borders(Microsoft.Office.Interop.Excel.XlBordersIndex.xlEdgeBottom).Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium
    chartrange.Resize(numofrecords, 6).WrapText = True
    chartrange.Resize(numofrecords, 6).EntireRow.AutoFit()
    chartrange.Resize(numofrecords, 6).Font.Size = 10
    chartrange.Resize(numofrecords, 6).HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter
    chartrange.Resize(numofrecords, 6).VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter
End Sub

ZurdoDev30-Mar-12 4:26

Re: merge cells with same values in microsoft office interop excel

30-Mar-12 4:26

Just record a macro doing what you want and then you can see what the code would look like and you can tweak it as necessary.

There are only 10 types of people in the world, those who understand binary and those who don't.

artemisxx1-Apr-12 15:16

Re: merge cells with same values in microsoft office interop excel

1-Apr-12 15:16

I haven't really had any experience working with macros before. So, like, I have no idea how that can help me. I'm sorry if I look like a total newbie, but that's because I am. Thanks for the idea though.

ZurdoDev2-Apr-12 1:53

Re: merge cells with same values in microsoft office interop excel

2-Apr-12 1:53

It depends on your version of Excel. Excel 2003 you use the Tools menu. You have Marco, Record Macro. Then you can go into the code and see what it generated. In 2007 and later I believe they are under the Design section of the Ribbon.

There are only 10 types of people in the world, those who understand binary and those who don't.

artemisxx2-Apr-12 14:11

Re: merge cells with same values in microsoft office interop excel

2-Apr-12 14:11

uhm..so, do i use the macro IN the template?

ZurdoDev3-Apr-12 1:58

Re: merge cells with same values in microsoft office interop excel

3-Apr-12 1:58

No, what you do is start recording a macro. Then do the actions you are interested in doing. Then stop recording the macro and then you can go and look at the code that was generated.

There are only 10 types of people in the world, those who understand binary and those who don't.

artemisxx3-Apr-12 14:17

why I am getting this error?

3-Apr-12 14:17

haha. now i understand what you mean. i'll do that. thanks! really, domo arigatou gozaimasu for being patient with me.

Jassim Rahma28-Mar-12 20:14

Jassim Rahma

28-Mar-12 20:14

Hi,

I am getting this error on my website when I uploaded it on host but I don't get the same on local? why is that?

XML

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load type 'JassimRahma.com.skills'.

Source Error:


Line 1:  <%@ Page Title="Skills" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="skills.aspx.cs" Inherits="JassimRahma.com.skills" %>
Line 2:
Line 3:  <%@ Register Assembly="DevExpress.Web.v11.1, Version=11.1.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"

Source File: /jassim/skills.aspx    Line: 1

Re: why I am getting this error?

Dalek Dave28-Mar-12 22:30

Dalek Dave

28-Mar-12 22:30

Have you checked the paths?
Confirm the name and extensions are consistent too.

Re: why I am getting this error?

ZurdoDev30-Mar-12 4:27

Placing C# into an ASP.net Form

30-Mar-12 4:27

You need to make sure the dll that has JassimRahma.com.skills is either in the servers GAC or in the bin folder of your site.

There are only 10 types of people in the world, those who understand binary and those who don't.

Paul Harsent28-Mar-12 5:02

Paul Harsent

28-Mar-12 5:02

I have a form for which I want the price to resemble the current price of an object. But I cant add any C# into this form. Im building a paypal program using MVC.

HTML

<%if (Roles.IsUserInRole("FullMember") == false)
{%>

<form action="https://www.sandbox.paypal.com/cgi-bin/webscr" method="post" target="paypal">

<input type="hidden" name="cmd" value="_cart">
<input type="hidden" name="add" value="1">

<input type="hidden" name="business" value="youremailaddress@yourdomain.com">

<input type="hidden" name="item_name" value="My Cart Item 1">

<input type="hidden" name="amount" value="10.00">
<input type="hidden" name="shopping_url" 
                                 value="http://localhost:30524/">

I want to place

HTML

<% item.price%>

Into the value-"10.00" place.

Is this possialbe and how do I go about doing this?

Thanks

Ali Al Omairi(Abu AlHassan)

Ali Al Omairi(Abu AlHassan)28-Mar-12 5:40

28-Mar-12 5:40

Do you mean this

HTML

<input type="hidden" name="amount" value="<%= item.price %>" />

Help people,so poeple can help you.

Paul Harsent28-Mar-12 8:28

Paul Harsent

28-Mar-12 8:28

Yes I do, but it doesnt work when I do that.

Ali Al Omairi(Abu AlHassan)

Ali Al Omairi(Abu AlHassan)28-Mar-12 11:02

28-Mar-12 11:02

where is the object item is declared? and what exception the code throw?

Help people,so poeple can help you.

modified 28-Mar-12 17:12pm.

Paul Harsent29-Mar-12 0:03

Paul Harsent

29-Mar-12 0:03

The object is been declared from the View when it is brought in from the model.

I can access the item.price object from outside the , it might just be a basic miss understanding.

value="50.00" I would like to be able to have value= <%item.price>% or something similar.

Thanks

HTML

<% foreach (var item in Model) { %>

    <tr>
        <td>
          <%= Html.Encode(item.Id)%>
        </td>
        <td>
            <%= Html.Encode(String.Format("{0:F}", item.Name))%>
        </td>
        <td>
            <%= Html.Encode(item.Description) %>
        </td>
        <td>
            <%= Html.Encode(String.Format("{0:F}", item.Price)) %>
        </td>

          <%if (Roles.IsUserInRole("FullMember") == false)
          {%>
           <td>
        <form action="https://www.sandbox.paypal.com/cgi-bin/webscr" method="post" target="paypal">

            <input type="hidden" name="cmd" value="_cart">
            <input type="hidden" name="add" value="2">

            <input type="hidden" name="business" value="Hull Press">
            <input type="hidden" name="item_name" value="Full Membership">

            <input type="hidden" name="amount" value="50.00">
            <input type="hidden" name="shipping" value="1.00">

            <input type="hidden" name="shopping_url"
                value="http://localhost:30524/Membership/SuccessfulMembership">
            <input type="hidden" name="return" value="http://localhost:30524/Membership/SuccessfulMembership">

            <input type="hidden" name="cancel_return" value="http://localhost:30524/Membership/CancelledMembership">
            <input type="hidden" name="bn" value="PP-ShopCartBF:x-click-but22.gif:NonHosted">

            <input type="image" src="https://www.paypal.com/en_US/i/btn/x-click-but22.gif" border="0"
                name="submit" alt="Make payments with PayPal - it's fast, free and secure!">

            <img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1"
                height="1">
        </form>
            </td>
        <%}
          else
          { %>
          <td>
          <%=Html.ActionLink("Read", "ViewItem", "item", new {itemID = item.Id,itemName = item.Name, itemDescription = item.Description, itemFullArt = item.FullArt, itemPrice = item.Price }, null)%>
          </td>
          <%} %>

Ali Al Omairi(Abu AlHassan)

Ali Al Omairi(Abu AlHassan)29-Mar-12 3:00

29-Mar-12 3:00

Have you tried this

<input type="hidden" name="amount" value="<%= item.price %>" />

, this

<input type="hidden" name="amount" value="<% item.price %>" />

or none.

Help people,so poeple can help you.