i am reading excel file in C# using microsoft.office.interop.excel. when the file having merged cells it is looping by containing number of cells in merged cell while i want the merged area at once  here is my method  public void ImportXLX()     {         Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();          Microsoft.Office.Interop.Excel.Workbook wb = app.Workbooks.Open(@"C:\Users\Vipin\Desktop\Sheets\MyXL6.xlsx", Type.Missing, Type.Missing, Type.Missing, Type.Missing,                 Type.Missing, Type.Missing, Type.Missing, Type.Missing,                 Type.Missing, Type.Missing, Type.Missing, Type.Missing,                 Type.Missing, Type.Missing);          int workSheetCounts = wb.Worksheets.Count;          for (int sheetCounter = 1; sheetCounter &lt;= workSheetCounts; sheetCounter++)         {             Microsoft.Office.Interop.Excel.Worksheet workSheet = wb.Sheets[sheetCounter];              Range excelRange = workSheet.UsedRange;             Range objRange = null;              int rowCount = 0;             float totalRowWidth = 0;             foreach (Microsoft.Office.Interop.Excel.Range row in excelRange.Rows)             {                 rowCount++;                 totalRowWidth = row.Width;                 int colCount = 0;                  foreach (Microsoft.Office.Interop.Excel.Range c in row.Cells)                 {                     colCount++;                     objRange = workSheet.Cells[rowCount, colCount];                      double width = 0;                     double height = 0;                     string colVal = null;                      if (objRange.MergeCells)                     {                         colVal = Convert.ToString(((Range)objRange.MergeArea[1, 1]).Text).Trim();                         width = objRange.MergeArea.Width;                         height = objRange.MergeArea.Height;                       }                     else                     {                         colVal = Convert.ToString(objRange.Text).Trim();                         width = objRange.Width;                         height = objRange.Height;                     }                     Debug.Write("objRange = " + objRange + " rowCount = " + rowCount + " Width = " + width + " height = " + height + "TotalColumnWidth = " + totalRowWidth + "TotalRowHeight = " + totalColHeight + " \n ");                 }             }         }         app.Quit();     }     here is the excel file screenshot  in this i want [3,1] [4,1] [5,1] [6,1] [7,1][8,1][9,1] cell just once in loop with its complete width and height
I have a database which contains 5 tables. Each table contains 24 rows and each row contains 4 columns.  I want to display these records in Excel sheet. The heading of each table is the name of the table, but I am unable to merge the columns for heading.  Please help me.
Best word for "unable to change" Error: mysqli_stmt::bind_param(): Number of elements in type definition string doesn't match number of bind variables It's a shame to type out an entire question, press post and then:     Sorry, you are only allowed to ask 50 questions in a 30 day period   Could you put some sort of notice on the page itself before submitting it to let you know the question won't be going through?  Or perhaps tell me how many questions I've asked in the last 30 days if it's >0?  Edit  This is not a complaint or statement about the limit, just a request that the error handling be done in a slightly better way to save people a lot of time. Regular expression: match start or whitespace Linux Equivalent of Windows Ctrl to show Mouse Pointer In Windows, it is possible to set pressing Ctrl to display the current location of the mouse pointer, as per .  Is there a way of setting a key or key combination to perform the same action in Ubuntu? Note, this is the opposite of turning this function off, as detailed at . Why is $a^n - b^n$ divisible by $a-b$? Theme Image Style for image located in module directory Probably coming at this from too much of a Drupal 6 view point but...  How do I theme an image in a given image style when that image lives in a module folder?  This is driving me batty and I know I'm just missing something simple.  Here is some example code showing what I'm trying to do:  $file_uri = 'public://sites/all/modules/my_module/logo.jpg'; $data['logo'] = theme('image_style', array('style_name' =&gt; 'medium', 'path' =&gt; $file_uri));   Even if I use file_build_uri(), I end up with a path to a file that doesn't exist. If I move the image to the files directory and change the $file_uri to 'public://logo.jpg', it works just fine.  Do I need to copy the image to the files directory as part of the module code?  If so, isn't this ridiculous?  What am I missing?  Is there documentation on how to do something like this?  I've spent over an hour mining the Drupal documentation and came up completely dry. I am nearing the end of my PhD and I would quite like to buy a "thank you" gift for my supervisor (although, she's the socially awkward type who I'm sure will be greatly embarrassed to receive one).  I'm just wondering whether a gift is the done thing? And if so, what sort of gift seems appropriate? I suppose a bottle of wine would be a safe choice? Level 10 vim adventures beers on the wall complete solution I saw this question  but it doesn't have a full solution. What is the full solution to the 99 bottles of beer on the wall for Vim adventures?  Context: for the sake of being a good SO member I will give more details but a full solution will answer my question. It seems from reading the other post that my register is incorrect for some reason. I can't get the &lt;NL&gt;. I think that's the issue since pasting won't work... Why do we yawn? I've read a new study which suggests that yawning may help you keep a cool head. Also, the findings might hold some hope for sufferers of insomnia, migraines, and even epilepsy.  Is there any conclusion about what the function of yawning is and why do we yawn? Showing that $\Bbb R[x] / \langle x^2 + 1 \rangle$ is isomorphic to $\Bbb C$ question If $G$ has no proper subgroup, prove that $G$ is cyclic of order $p$, where $p$ is a prime number.     I know that since $G $is a group with no proper subgroups, $g \in G$ is not just the identity. I don't know where to go from there. As far as I can tell downvoting is mostly useless.     For questions the only people who get downvoted are lower rep users, or incredibly stupid questions    most questions that are downvoted get closed anyway which should be sufficient downvoting doesn't have too much affect on your rep anyway a negative comment is more useful and more of a push too change or delete the question  For answers downvoting is often used incorrectly as well   people commonly competitively downvote (downvoting another answer to a question that you also answered) obviously not a good behavior downvoting (and upvoting) are contagious, meaning one downvote leads to a bunch of others even though downvotes don't effect rep that much they create a negative environment, no one wants their post downvoted, on the other hand criticizing comments, I think, are far more welcome      So basically in a nutshell a downvote serves no real purpose even if a post deserves it. Flagging, closing and commenting are much more useful to everyone including the poster than downvoting so why have it.    I now see from the answers and comments that downvotes do serve a purpose and would like to retract my request. Double line spacing Two numbers are chosen randomly and independently from the unit interval $(0,1)$.  What is the probability that they differ by more than $\frac{1}{2}$? Hint: Think of the $2$ numbers chosen as coordinates in the Cartesian plane. Draw a square with vertices at $(0,0)$,$(1,0)$,$(1,1)$, and $(0,1)$. Allowable choices for the $2$ points lie below the line $y=x-\frac{1}{2}$ or the above $y=x+\frac{1}{2}$. Find the combined area of these regions.  I need help on this. I know what $y=x-\frac{1}{2}$ and $y=x+\frac{1}{2}$ looks like but I am not understanding the problem as a whole S tabular with alignment Why is an untranslated string not showing up? In my module I have some custom strings. I use these in the t() function. When I go to admin/config/regional/translate/translate and filter the untranslated strings my custom strings do not show here.  What could be going wrong? 554 5.7.1 : Relay access denied centos postfix I have problem in send mail from postfix in centos  I have following  for sending mail but I am getting error.  As in the link I tried following commands  telnet localhost smtp  Trying ::1... Connected to localhost. Escape character is '^]'. 220 mydomain.com ESMTP Postfix ehlo localhost 250-mydomain.com 250-PIPELINING 250-SIZE 10240000 250-VRFY 250-ETRN 250-ENHANCEDSTATUSCODES 250-8BITMIME 250 DSN mail from:&lt;domain.com&gt; 250 2.1.0 Ok rcpt to:&lt;test@gmail.com&gt; 554 5.7.1 &lt;test@gmail.com&gt;: Relay access denied   Edit-1  In terminal this works  echo TEST | mail -v -s "Test mail" testing@gmail.com   my postconf -n shows belog information  alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix data_directory = /var/lib/postfix debug_peer_level = 2 home_mailbox = Maildir/ html_directory = no inet_interfaces = localhost inet_protocols = all mail_owner = postfix mailq_path = /usr/bin/mailq.postfix manpage_directory = /usr/share/man mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain mydomain = dummy.com myhostname = dummy.com mynetworks = all mynetworks_style = host myorigin = $mydomain newaliases_path = /usr/bin/newaliases.postfix queue_directory = /var/spool/postfix readme_directory = /usr/share/doc/postfix-2.6.6/README_FILES sample_directory = /usr/share/doc/postfix-2.6.6/samples sendmail_path = /usr/sbin/sendmail.postfix setgid_group = postdrop unknown_local_recipient_reject_code = 550   What configuration I have to perform to send mails from my server. How do I find a command if I don't know its name? As a Unix beginner, I often find myself wanting to know the name of the command that achieves a particular function I'm after. How can I go about finding out the name of the command, given a description of what it does? I have two separate Armatures that I want to join together. I have no problem combining the meshes, but the problem is the bones/rigs. When you do the Object mode > join, I lose all of my weight paint on one of my armatures. Is there any way I can join two separate armatures and keep all the weight paint. I turn my models into XPS and use XNA Lara to view them, but XNAlara cannot use both armatures at once.