Open xml speadsheet border & bold problems

Question

I have been trying to work with Open XML in making a speadsheet.  I have attached the code that puts the data in the spreadsheet.  I let the productivity tool create the header and put it in a class.  I execute the class then open the speadsheet and then edit it..

I need a border around the data cells.  I get them for the strings, but everything is bold.  I need to do this without everything being bold.  The Charges field, the 11 column needs to handled differently with a deciamal in it.  I do not get the border around these cells.

Can anyone help or suggest somewhere to go?

I hope this is understandable.


Thanks,
arep

Answer 1

Hi..

Datatable has 4500 records. It is not empty.

 

Yes, I have mentioned all the lines...

 

cmd.CommandType = Stored Procedure 

----------

Hi all...

 

I have one more query.... Instead of WCF Service , now I am asked to do .asmx web service.

 

I need the user to insert the following values -

1. Name - string values - no number 

2. Location - String values

3. Email ID - [e-mail] - check if email id is valid

4. Mobile Number - Numeric values

5. Date - date must be greater than current date.

6. Select city from drodownlist.

----------

 For this, I have made -

1. A Class File with get; set properties (UserDetailsProperties.cs - Name of Class File).

2. I have made a method to return Boolean with Class Name as parameter.

public Boolean IsDataIserted(UserDetailsProperties userdetails)

{

cmd = new SQLCommand();

cmd.Parameters.AddWithValues("@Name", userdetails.Name);

int i=cmd.ExecuteNonQuery();

if(i<=0)return true;

else return false;

}

-----------

My Query is -

How do I test this functionality with .asmx service ?

 

http://localhost:12456/UserWebService.asmx - This is the URL.

 

------

And how do I get the output in JSON?

--------------------

 When I upload the webservice in server (iis), then is there a way so that instead of fields , we can have dropdownlist , datetime picker as inputs ?

This is when - we hit the url - http://1.2.3.4/UserDetails/UserWebService.asmx - click on the method and click on "Invoke" button.

------------

Please guide

 -----------------------------------------------

Dear All...

Once again I am stuck up with Basic Authentication of the Web Service...

 

Requirement - When the user hits the URL - http://localhost:34789/WebService1.asmx ; then

1. A popup or method must be displayed -  Please enter Username and Password.

 

2. If the user enters "Riddhi" in Username and "12345" in Password, then the message should be displayed -  Successfully Logged In... and display other Web Methods - Add ,Subtract, Multiply, Divide 

 

3. Else - A message - "Authentication failed" - must be displayed.

 Please guide for this... 

 

 

Answer 2

Hi riddhi,

 

You might be getting this error coz your datatable is empty.

 

 since you are using a SP, so you need to include following line in GetUserList() method 

 

cmd.CommandType = CommandType.StoredProcedure;

 

Also check if your connection string is valid or not