For BIFF&lt;n&gt; .xls files

    application/vnd.ms-excel

For Excel2007 and above .xlsx files

    application/vnd.openxmlformats-officedocument.spreadsheetml.sheet



    application/vnd.ms-excel

* ``vnd class`` / vendor specific
* [http://en.wikipedia.org/wiki/Microsoft_Excel#File_formats][1]


  [1]: http://en.wikipedia.org/wiki/Microsoft_Excel#File_formats

Do keep in mind that the `file.getContentType` could also output **application/octet-stream** instead of the required **application/vnd.openxmlformats-officedocument.spreadsheetml.sheet** when you try to upload the file that is already open.

How do I pass authorization header using cURL? ( executable in `/usr/bin/curl`).

How to set the authorization header using cURL

I&#39;m trying to get the hang of ES6 imports in Node.js and am trying to use the syntax provided in this example:

### [Cheatsheet Link][1]

I&#39;m looking through [the support table][2], but I was not able to find what version supports the new import statements (I tried looking for the text import/require). I&#39;m currently running Node.js 8.1.2 and also believe that since the cheatsheet is referring to .js files it should work with .js files.

As I run the code (taken from the cheatsheet&#39;s first example):

    import { square, diag } from &#39;lib&#39;;

I get the error:

&gt; SyntaxError: Unexpected token import.

Reference to library I&#39;m trying to import:

    //------ lib.js ------
    export const sqrt = Math.sqrt;
    export function square(x) {
        return x * x;
    }
    export function diag(x, y) {
        return sqrt(square(x) + square(y));
    }

What am I missing and how can I get `node` to recognize my `import` statement?

  [1]: https://hackernoon.com/import-export-default-require-commandjs-javascript-nodejs-es6-vs-cheatsheet-different-tutorial-example-5a321738b50f
  [2]: http://node.green/





How can I use an ES6 import in Node.js?

I want excel files on a website to open in Excel when clicked, not get saved on desktop, or get opened embedded in a browser etc. Now obviously it all depends on how everything is configured for each user, but what&#39;s the best Content-Type and other settings to achieve just that most of the time?

What is correct content-type for excel files?

<p>I want excel files on a website to open in Excel when clicked, not get saved on desktop, or get opened embedded in a browser etc. Now obviously it all depends on how everything is configured for each user, but what's the best Content-Type and other settings to achieve just that most of the time?</p>


Is there any built-in functionality in [tag:VBA] to get unique values from a one-dimensional array? What about just getting rid of duplicates?

If not, then how would I get the unique values from an array?

vba: get unique values from array

I have an array like this:

    Dim aFirstArray() As Variant

How do I clear the entire array?
What about a collection?

How to clear the entire array?

I am trying to display milliseconds in an Excel macro.  I have a column of integers which are timestamps in milliseconds (e.g. 28095200 is 7:48:15.200 am), and I want to make a new column next to it which keeps a running average and displays the time in a &lt;code&gt;hh:mm:ss.000&lt;/code&gt; format.  

     Dim Cel As Range
     Set Cel = Range(&quot;B1&quot;)
     temp = Application.Average(Range(&quot;A1:A2&quot;)) / 1000
     ms = Round(temp - Int(temp), 2) * 1000
     Cel.Value = Strings.Format((temp / 60 / 60 / 24), &quot;hh:mm:ss&quot;) _
                    &amp; &quot;.&quot; &amp; Strings.Format(ms, &quot;#000&quot;)

This only displays &quot;mm:ss.0&quot; in the cell.  Yet when I click on the cell, it shows &quot;hh:mm:ss&quot; in the formula bar.  Why are the hours missing? How can I show the hours, minutes, seconds, and milliseconds?

Display milliseconds in Excel

I&#39;m using Apache POI 3.6, I want to read an excel file which has a date like this `8/23/1991`.


     switch (cell.getCellType()) {
    
       ...
       ...
    
       case HSSFCell.CELL_TYPE_NUMERIC:
         value = &quot;NUMERIC value=&quot; + cell.getNumericCellValue();
         break;
    
       ...
    
     }

But it takes the numeric value type and returns the value like this `33473.0`.

I&#39;ve tried to use Numeric Cell Type although with no luck.

     
    dbltemp=row.getCell(c, Row.CREATE_NULL_AS_BLANK).getNumericCellValue();

    if (c == 6 || c == 9) {
        strTemp= new String(dbltemp.toString().trim());
    
        long tempDate = Long.parseLong(strTemp);
        Date date = new Date(tempDate);
    
        strVal = date.toString();
    }
    

How can I fix my problem? 



How to read Excel cell having Date with Apache POI?

How can I append text to every cell in a column in Excel? I need to add a comma (&quot;,&quot;) to the end.

**Example:** 

`email@address.com` turns into `email@address.com,`

**Data Sample:**

    m2engineers@yahoo.co.in
    satishmm_2sptc@yahoo.co.in
    threed_precisions@rediffmail.com
    workplace_solution@yahoo.co.in
    threebworkplace@dataone.in
    dtechbng@yahoo.co.in
    innovations@yahoo.co.in
    sagar@mmm.com
    bpsiva@mmm.com
    nsrinivasrao@mmm.com
    pdilip@mmm.com
    vvijaykrishnan@mmm.com
    mrdevaraj@mmm.com
    b3minvestorhelpdesk@mmm.com
    sbshridhar@mmm.com
    balaji@mmm.com
    schakravarthi@mmm.com
    srahul1@mmm.com
    khramesh2@mmm.com
    avinayak@mmm.com
    rockindia@hotmail.com

Append same text to every cell in a column in Excel

I thought I should send &quot;text/xml&quot;, but then I read that I should send &quot;application/xml&quot;. Does it matter? Can someone explain the difference?

What Content-Type value should I send for my XML sitemap?

As far as I know, they are absolute equal. However, browsing some django docs, I&#39;ve
found this piece of code:

`HttpResponse.__init__(content=&#39;&#39;, mimetype=None, status=200, content_type=&#39;text/html&#39;)`

which surprise me the two getting along each other. The official docs was able to solve the issue in a pratical manner:

&gt; content_type is an alias for mimetype.
&gt; Historically, this parameter was only
&gt; called mimetype, but since this is
&gt; actually the value included in the
&gt; HTTP Content-Type header, it can also
&gt; include the character set encoding,
&gt; which makes it more than just a MIME
&gt; type specification. If mimetype is
&gt; specified (not None), that value is
&gt; used. Otherwise, content_type is used.
&gt; If neither is given, the
&gt; DEFAULT_CONTENT_TYPE setting is used.

However, I don&#39;t find it elucidating enough. Why we use 2 different naming for (almost the same) thing? Is &quot;Content-Type&quot; just a name used in browser requests, and with very little use outside it?

What&#39;s the main difference between the each one, and when is right to call something `mimetype` as opposed to `content-type` ? Am I being pitty and grammar nazi?

What&#39;s the difference of ContentType and MimeType

In FF and all, my javascript works fine. But in Chrome it gives this message: 
&gt;Resource interpreted as script but transferred with MIME type text/plain.

I have checked all the script tags and they all have the `MIME type=&quot;text/javascript&quot;`. It even says so with jquery and jquery ui. What is wrong with Chrome?

What&#39;s the problem and the fix for this? Is it something I have to change in the &#39;options&#39; of the browser or is it from the server, or do I have to tweak my code?

Chrome says &quot;Resource interpreted as script but transferred with MIME type text/plain.&quot;, what gives?

Whenever I try to get the mime content type from php, it echos:

&gt;**Fatal error:** Class &#39;finfo&#39; not found in **/home/jobynadel/finadel.com/video/finfo.php** on line **4**

or

&gt;**Fatal error:** Call to undefined function finfo_open in **/home/jobynadel/finadel.com/video/finfo.php** on line **4**

I just can&#39;t figure it out!

The code I am using is:

    $file_info = new finfo(FILEINFO_MIME_TYPE);
    // See constant value http://php.net/manual/en/fileinfo.constants.php#113687 
    $mime_type = $file_info-&gt;buffer(file_get_contents($file));

PHP fileinfo is undefined function

I have been reading about how to build plug-ins and this &quot;MIME type&quot; keeps getting discussed in it. I have tried to look into it and know that it is Multipurpose Internet Mail Extensions (MIME) but no suitable explanation of how it relates to browser plug-ins, as in what I need to know about it for building plug-ins, is provided, please explain in clear and simple words. What is it? Why do plug-ins have a MIME type?

Content Type	Original Author	Original Content on Stackoverflow
Question	taw	View Question on Stackoverflow
Solution 1 - Excel	Mark Baker	View Answer on Stackoverflow
Solution 2 - Excel	miku	View Answer on Stackoverflow
Solution 3 - Excel	DiTap	View Answer on Stackoverflow

What is correct content-type for excel files?

Excel Problem Overview

Excel Solutions

Solution 1 - Excel

Solution 2 - Excel

Solution 3 - Excel

How can I use an ES6 import in Node.js?

How to set the authorization header using cURL

Attributions